IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQL code from Stored procedure in DB2
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
rosmi joseph

New User


Joined: 17 Sep 2007
Posts: 68
Location: Kochi
PostPosted: Thu Sep 24, 2009 2:23 pm
 Reply with quote
Hi,

Can anyone please let me know how we can get SQL code from a stored procedure? Also is it possible to handle SQL code within a stored proc.

Thanks.
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
PostPosted: Thu Sep 24, 2009 2:49 pm
 Reply with quote
Use OUT parameters in SP. Use EXCEPTION HANDLErs for handling SQLCODE's.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
PostPosted: Thu Sep 24, 2009 2:55 pm
 Reply with quote
Do you mean the error code sqlcode or the source code of the sql?

Are you talking about external or sql native stored procedures ?


start reading : www.redbooks.ibm.com/abstracts/sg247083.html?Open
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Monitoring production job progress. N... JCL & VSAM 4
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us