Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Powerbuilder does not support mysql stored procedure which contain result set

5 posts in DataWindow Last posting was on 2009-12-02 09:33:33.0Z
Pash Posted on 2009-11-28 14:30:02.0Z
From: Pash <prashant.nirgun@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Powerbuilder does not support mysql stored procedure which contain result set
Date: Sat, 28 Nov 2009 06:30:02 -0800 (PST)
Organization: http://groups.google.com
Lines: 20
Message-ID: <be3af26d-debf-4e52-b57a-42da8a4864bb@g10g2000pri.googlegroups.com>
NNTP-Posting-Host: 120.62.6.206
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1259418603 2589 127.0.0.1 (28 Nov 2009 14:30:03 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 28 Nov 2009 14:30:03 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g10g2000pri.googlegroups.com; posting-host=120.62.6.206; posting-account=58ybXQoAAADc3nGASDx894hJ3ZcyDGTI
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g10g2000pri.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90360
Article PK: 409965

Hi Prashant here i am using following version

PB : Powerbuilder 7 & 9
RDBMS : Mysql 5.1.36 Windows binary 32bit
DOBC : Mysql ODBC Driver 5.1.6
Problem : I had written a stored procedure in mysql which is nothing
but a result set here is syntax
Community : Freeware Software Developement

CREATE PROCEDURE test_rpt (in coid int)
begin
select co_id, it_name from item where co_id = 1;
end

But if i create a datawindow report it wont run and in my databse
painter also i try to run the procedure in isql
windows it gives me an error "The database does not currently support
retrieval of procedure text.;"

What it is? is there any way out to solve this problem.


"Paul Horan[Sybase]" <phoran_remove Posted on 2009-11-29 01:46:29.0Z
From: "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <be3af26d-debf-4e52-b57a-42da8a4864bb@g10g2000pri.googlegroups.com>
Subject: Re: Powerbuilder does not support mysql stored procedure which contain result set
Lines: 31
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b11d275@forums-1-dub>
Date: 28 Nov 2009 17:46:29 -0800
X-Trace: forums-1-dub 1259459189 10.22.241.152 (28 Nov 2009 17:46:29 -0800)
X-Original-Trace: 28 Nov 2009 17:46:29 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90361
Article PK: 409966

To be honest, both of those products are well past their EOL dates, so
Sybase's only response can be "upgrade to a supported version".

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

"Pash" <prashant.nirgun@gmail.com> wrote in message
news:be3af26d-debf-4e52-b57a-42da8a4864bb@g10g2000pri.googlegroups.com...
> Hi Prashant here i am using following version
>
> PB : Powerbuilder 7 & 9
> RDBMS : Mysql 5.1.36 Windows binary 32bit
> DOBC : Mysql ODBC Driver 5.1.6
> Problem : I had written a stored procedure in mysql which is nothing
> but a result set here is syntax
> Community : Freeware Software Developement
>
> CREATE PROCEDURE test_rpt (in coid int)
> begin
> select co_id, it_name from item where co_id = 1;
> end
>
> But if i create a datawindow report it wont run and in my databse
> painter also i try to run the procedure in isql
> windows it gives me an error "The database does not currently support
> retrieval of procedure text.;"
>
> What it is? is there any way out to solve this problem.


Peter Piechutzki Posted on 2009-11-30 13:16:13.0Z
From: "Peter Piechutzki" <ppiechutzki@chriwa.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <be3af26d-debf-4e52-b57a-42da8a4864bb@g10g2000pri.googlegroups.com> <4b11d275@forums-1-dub>
Subject: Re: Powerbuilder does not support mysql stored procedure which contain result set
Lines: 76
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
X-EsetScannerBuild: 6135
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b13c59d@forums-1-dub>
Date: 30 Nov 2009 05:16:13 -0800
X-Trace: forums-1-dub 1259586973 10.22.241.152 (30 Nov 2009 05:16:13 -0800)
X-Original-Trace: 30 Nov 2009 05:16:13 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90371
Article PK: 409977

@Paul:
hmm, so updating to PB 11.5 fully ensures MySql support?

@Pash: don't bet on it, we're using MySQL in production environment scince
PB 10, are now on PB 11.5.1 and still recieve "The database does not
currently support retrieval of procedure text." Allthough recieving this
message we at least can use a stored procedure as Datasource for a
Datawindow (tested in our current PB 11.5.1). We just can't see the actual
code of the procedure.

Another drawback with PB<->MYSQL I think worth mentioning is that it takes a
very long time (at least 5secs) for the IDE to retrieve the datwindow source
of any datawindow. This seems due to slow response on Primary and Foreign
Key retrieval.

It would be so great if Sybase would enhance the support of MySql via ODBC
or even implement a direkt interface.

It may also be of interest to you, that we modified our PBODBC.INI to
include a Mysql section which allows us at least to use Identity Columns
with MySql:

>[MySQL]
>PBSyntax='MySQL_SYNTAX'
>
>[MySQL_SYNTAX]
>GetIdentity='Select @@identity'

regards

Peter
PB: Powerbuilder 11.5.1 Build 4608
RDBMS: MySQL 5.0.51b
DODBC: Mysql Client 5.1.11
Problem: same as Pash





"Paul Horan[Sybase]" <phoran_remove@remove_sybase.com> schrieb im
Newsbeitrag news:4b11d275@forums-1-dub...
> To be honest, both of those products are well past their EOL dates, so
> Sybase's only response can be "upgrade to a supported version".
>
> --
> Paul Horan[Sybase]
> http://blogs.sybase.com/phoran/
>
> "Pash" <prashant.nirgun@gmail.com> wrote in message
> news:be3af26d-debf-4e52-b57a-42da8a4864bb@g10g2000pri.googlegroups.com...
>> Hi Prashant here i am using following version
>>
>> PB : Powerbuilder 7 & 9
>> RDBMS : Mysql 5.1.36 Windows binary 32bit
>> DOBC : Mysql ODBC Driver 5.1.6
>> Problem : I had written a stored procedure in mysql which is nothing
>> but a result set here is syntax
>> Community : Freeware Software Developement
>>
>> CREATE PROCEDURE test_rpt (in coid int)
>> begin
>> select co_id, it_name from item where co_id = 1;
>> end
>>
>> But if i create a datawindow report it wont run and in my databse
>> painter also i try to run the procedure in isql
>> windows it gives me an error "The database does not currently support
>> retrieval of procedure text.;"
>>
>> What it is? is there any way out to solve this problem.
>
>


Chris Keating (Sybase iAnywhere) Posted on 2009-11-30 17:26:34.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Powerbuilder does not support mysql stored procedure which contain result set
References: <be3af26d-debf-4e52-b57a-42da8a4864bb@g10g2000pri.googlegroups.com>
In-Reply-To: <be3af26d-debf-4e52-b57a-42da8a4864bb@g10g2000pri.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b14004a$1@forums-1-dub>
Date: 30 Nov 2009 09:26:34 -0800
X-Trace: forums-1-dub 1259601994 10.22.241.152 (30 Nov 2009 09:26:34 -0800)
X-Original-Trace: 30 Nov 2009 09:26:34 -0800, vip152.sybase.com
Lines: 40
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90374
Article PK: 409980

Does the MySQL ODBC driver support the underlying calls needed to
determine the resultset? Perhaps you can run an ODBC trace that captures
this problem behaviour and post here for review. I think PB calls
SQLNumResultCols and SQLDescribeCol to determine the schema.

As for the message "The database does not currently support
retrieval of procedure text.", I doubt that would impact the invoking of
a procedure but will create issues in the datawindow and database
painters that attempt to display the precedure syntax. Since this is
generally specific to the vendor, the statement used to get this
information is usually defined in the PBODBx.INI file in the section
related to the ODBC driver that is being used. Since MySQL has no entry
in that file, PB has no knowledge of how to retrieve this syntax and
reports this message. You can add this into the file. There is
documentation related to this at the end of the file.

-chris

Pash wrote:
> Hi Prashant here i am using following version
>
> PB : Powerbuilder 7 & 9
> RDBMS : Mysql 5.1.36 Windows binary 32bit
> DOBC : Mysql ODBC Driver 5.1.6
> Problem : I had written a stored procedure in mysql which is nothing
> but a result set here is syntax
> Community : Freeware Software Developement
>
> CREATE PROCEDURE test_rpt (in coid int)
> begin
> select co_id, it_name from item where co_id = 1;
> end
>
> But if i create a datawindow report it wont run and in my databse
> painter also i try to run the procedure in isql
> windows it gives me an error "The database does not currently support
> retrieval of procedure text.;"
>
> What it is? is there any way out to solve this problem.


Pash Posted on 2009-12-02 09:33:33.0Z
From: Pash <prashant.nirgun@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Powerbuilder does not support mysql stored procedure which contain result set
Date: Wed, 2 Dec 2009 01:33:33 -0800 (PST)
Organization: http://groups.google.com
Lines: 7
Message-ID: <0e498a0e-8a79-4014-ac08-d91061bda25c@b15g2000yqd.googlegroups.com>
References: <be3af26d-debf-4e52-b57a-42da8a4864bb@g10g2000pri.googlegroups.com> <4b14004a$1@forums-1-dub>
NNTP-Posting-Host: 120.62.7.91
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1259746413 30882 127.0.0.1 (2 Dec 2009 09:33:33 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 2 Dec 2009 09:33:33 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b15g2000yqd.googlegroups.com; posting-host=120.62.7.91; posting-account=58ybXQoAAADc3nGASDx894hJ3ZcyDGTI
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!b15g2000yqd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90383
Article PK: 409987

reply to "Chris Keating (Sybase iAnywhere)"
<keating_nos...@sybase.com>

Does any body have that string [mysql_syntax] if u can put it on group
that will be g8 help for me

Thanks in advance