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.

Calling Stored procedure through DB lib in C

2 posts in Windows NT Last posting was on 1999-05-07 11:56:29.0Z
Sumedh Thakar Posted on 1998-04-28 05:48:43.0Z
Message-ID: <35456DBB.FA372CEB@pcsbom.patni.com>
Date: Tue, 28 Apr 1998 11:18:43 +0530
From: Sumedh Thakar <thakarss@pcsbom.patni.com>
Organization: Patni Computer Systems Ltd., INDIA
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
Subject: Calling Stored procedure through DB lib in C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5047
Article PK: 1092411

-- If i have a statement in my stored procedure 'return 5' then through DB lib
how can i trap this return value.
Sumedh
---------------------------------------------------
Sumedh Thakar
Patni Computer Systems Ltd., INDIA
Software Tech. Park, MIDC, Bhosari, Pune 411 026
E-mail: thakarss@pcsbom.patni.com
Tel : [O] +91-212-792727 +91-212-799125 Ext: 271
[R] +91-212-337069
Fax : [O] +91-212-791882
Home Page: http://www.patni.com


decox Posted on 1999-05-07 11:56:29.0Z
Message-ID: <3732D4EC.76D6255C@ibm.net>
Date: Fri, 07 May 1999 07:56:29 -0400
From: decox@ibm.net
Reply-To: decox@ibm.net
X-Mailer: Mozilla 4.51 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Calling Stored procedure through DB lib in C
References: <35456DBB.FA372CEB@pcsbom.patni.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 16
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:3797
Article PK: 1091188

I believe the dblib statement you are look for is "restatus" it returns the status
from the stored procedure.

Sumedh Thakar wrote:

> -- If i have a statement in my stored procedure 'return 5' then through DB lib
> how can i trap this return value.
> Sumedh
> ---------------------------------------------------
> Sumedh Thakar
> Patni Computer Systems Ltd., INDIA
> Software Tech. Park, MIDC, Bhosari, Pune 411 026
> E-mail: thakarss@pcsbom.patni.com
> Tel : [O] +91-212-792727 +91-212-799125 Ext: 271
> [R] +91-212-337069
> Fax : [O] +91-212-791882
> Home Page: http://www.patni.com