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

Will cursor be closed once control back to the main program


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

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Fri Oct 20, 2006 9:26 am
Reply with quote

Hi
My main program is calling a subroutine (online ) ..in sub a cursor is opened ...but in case the control is returned back bfore i can close the cursor will the cursor be closed once control goes back to the main program ..... the subroutine can again be called from the main program depending on the feedback frm the sub ......
pls help ...

tia
Back to top
View user's profile Send private message
MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Fri Oct 20, 2006 7:51 pm
Reply with quote

Cursor will not be closed, application has to close the cursor.

Normally in this scenario, it is better to have control in calling program.
Call once with OPEN cursor.
Fetch
Close Cursor when processing is done.
Back to top
View user's profile Send private message
UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 771
Location: Germany

PostPosted: Fri Oct 20, 2006 9:04 pm
Reply with quote

Hi !

Have a look at the other topic where you posted the same.

Regards, UmeySan
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 Using API Gateway from CICS program CICS 0
No new posts Using Dynamic file handler in the Fil... COBOL Programming 2
No new posts DB2 Event passed to the Application P... DB2 1
No new posts How to pass the PARM value to my targ... COBOL Programming 8
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
Search our Forums:

Back to Top