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

If no explicit cursor closage


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

New User


Joined: 09 Jan 2006
Posts: 5

PostPosted: Wed Jan 11, 2006 12:43 pm
Reply with quote

Hi

Will the DB2 changes be commited when no explicit close cursor is given?

Prabhu
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 463

PostPosted: Wed Jan 11, 2006 12:48 pm
Reply with quote

Hi,

Quote:
Will the DB2 changes be commited when no explicit close cursor is given?


Before ending programm, all teh changes will be commited.

Regards
Rupesh
Back to top
View user's profile Send private message
prabhu2006

New User


Joined: 09 Jan 2006
Posts: 5

PostPosted: Wed Jan 11, 2006 2:38 pm
Reply with quote

Hi

Assuming no commit is given explicitly and no close cursor is also stated, will the changes still be commited after the program is complete?
Back to top
View user's profile Send private message
reachsenthilnathan

New User


Joined: 20 Nov 2005
Posts: 15

PostPosted: Sun Jan 22, 2006 7:33 pm
Reply with quote

Yes. All the cursors will be closed, when program ends and all your operations will be automatically commited.

With regards,
Senthil Nathan.R
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 Is SQLCODE -811 possible while fetchi... DB2 1
No new posts Restart logic by using cursor name in... DB2 1
No new posts Seeking Resolution for SQKCODE -991 o... DB2 2
No new posts Multiple rows within Cursor when Coun... DB2 14
No new posts Dynamic cursor name in Cobol program COBOL Programming 1
Search our Forums:

Back to Top