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.

How to get the output from SP through RUN() in PB 8.0

2 posts in Objects Last posting was on 2008-06-23 19:13:37.0Z
ksvimal Posted on 2008-06-23 14:59:15.0Z
From: ksvimal <rush2vimal@gmail.com>
Newsgroups: sybase.public.powerbuilder.objects
Subject: How to get the output from SP through RUN() in PB 8.0
Date: Mon, 23 Jun 2008 07:59:15 -0700 (PDT)
Organization: http://groups.google.com
Lines: 17
Message-ID: <f97532b8-0206-498a-b0f5-5707a47a2972@i36g2000prf.googlegroups.com>
NNTP-Posting-Host: 122.166.89.138
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1214233155 13785 127.0.0.1 (23 Jun 2008 14:59:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 23 Jun 2008 14:59:15 +0000 (UTC)
Cc: vimal.raj@xsysys.com
Complaints-To: groups-abuse@google.com
Injection-Info: i36g2000prf.googlegroups.com; posting-host=122.166.89.138; posting-account=OxSYgwoAAADHjRDjJjl0f0U_QwmVHF2W
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14,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!i36g2000prf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9737
Article PK: 736869

Hi,


Consider that the stored procedure sp_test returns the value 2.

I am running this stored procedure through the RUN() in Powerbuilder
8.0

Integer li_return
li_return = RUN(dbisqlc.exe CALL -c "DSN=Test"sp_test)

Above statement excutes the stored procedure without any error.
but i want to know how to get the output 2.

Please help me to get the output from SP through RUN()

Thanks.


Terry Dykstra Posted on 2008-06-23 19:13:37.0Z
Reply-To: "Terry Dykstra" <dontreply_tddykstra@forestoil.ca.x>
From: "Terry Dykstra" <tddykstra@forestoil.ca>
Newsgroups: sybase.public.powerbuilder.objects
References: <f97532b8-0206-498a-b0f5-5707a47a2972@i36g2000prf.googlegroups.com>
Subject: Re: How to get the output from SP through RUN() in PB 8.0
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <485ff5e1$1@forums-1-dub>
Date: 23 Jun 2008 12:13:37 -0700
X-Trace: forums-1-dub 1214248417 10.22.241.152 (23 Jun 2008 12:13:37 -0700)
X-Original-Trace: 23 Jun 2008 12:13:37 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9738
Article PK: 736868

Please don't crosspost. I've answered in a different group.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"ksvimal" <rush2vimal@gmail.com> wrote in message
news:f97532b8-0206-498a-b0f5-5707a47a2972@i36g2000prf.googlegroups.com...
> Hi,
>
>
> Consider that the stored procedure sp_test returns the value 2.
>
> I am running this stored procedure through the RUN() in Powerbuilder
> 8.0
>
> Integer li_return
> li_return = RUN(dbisqlc.exe CALL -c "DSN=Test"sp_test)
>
> Above statement excutes the stored procedure without any error.
> but i want to know how to get the output 2.
>
> Please help me to get the output from SP through RUN()
>
> Thanks.