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

Cursor with return vs out parameters in stored proc
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Raghuraman_New

New User


Joined: 03 Oct 2008
Posts: 43
Location: Chennai,India.
PostPosted: Tue Nov 10, 2009 7:05 pm
 Reply with quote
1)In stored procs , does using cursor with return options is better than moving the resultant set to out parameters ?
2)If yes ! could you please explain why it is so ?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
PostPosted: Tue Nov 10, 2009 7:19 pm
 Reply with quote
DB2 9 for z/OS Stored Procedures: Through the CALL and beyond

DB2 z/OS Stored Procedures: Through the CALL and beyond
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 Return codes-Normal & Abnormal te... JCL & VSAM 7
No new posts Passing Parameters to Programs Invoke... PL/I & Assembler 5
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Injecting HTTPHEADER parameters in th... PL/I & Assembler 0
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