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

DB2 Internal stored procedure output


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Abhi Gautam

New User


Joined: 25 May 2006
Posts: 1
Location: pune

PostPosted: Tue May 30, 2006 5:32 pm
Reply with quote

[/b] I am calling an internal stored procedure in my Cobol program, Which supposed to give me a result set. However the stored procedure does not have any out parameters. Please suggest me how would I retrieve the data from the stored procedure in the cobol program?
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Tue May 30, 2006 11:43 pm
Reply with quote

Abhi Gautam

I think you are going to have to take a close look at the stored procedure. What function does it perform? If there is no OUT parameters, it must update some tables? You will have to print the table rows the stored procdure affects, before and after you're call.

Please come back with more detail

Dave
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 TRIM everything from input, output co... DFSORT/ICETOOL 1
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
No new posts Build a record in output file and rep... DFSORT/ICETOOL 11
No new posts XDC SDSF output to temp dataset CLIST & REXX 4
Search our Forums:

Back to Top