View previous topic :: View next topic
|
Author |
Message |
vickyarora81
New User
Joined: 20 Feb 2006 Posts: 4
|
|
|
|
Hi,
I just wanted to do know whether commit is required for retreival only program and i am not using any obtain exclusive........ |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
I don't know. I would think that if you read a row and then just waited for 12 or so hours doing nothing, that an update and commit to that row by another program might be hindered....maybe only if you had a cursor with CS or RR?
What say the DB2 gurus? |
|
Back to top |
|
|
vickyarora81
New User
Joined: 20 Feb 2006 Posts: 4
|
|
|
|
Hi William,
Thanks for the reply but I asking in regard to IDMS..... |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Good point, That's what I get for not looking at which forum the thread is in...... |
|
Back to top |
|
|
jeevankumar
New User
Joined: 06 Mar 2007 Posts: 2 Location: columbus oh
|
|
|
|
Hi,
Normally, the retrieval mode do not maintain area/record locks on the database. So 'commit' is not required for retrieval programs.
Please correct me if I am wrong.
Thanks |
|
Back to top |
|
|
tosaurabh20
New User
Joined: 08 Jun 2007 Posts: 26 Location: Noida
|
|
|
|
jeevankumar wrote: |
Hi,
Normally, the retrieval mode do not maintain area/record locks on the database. So 'commit' is not required for retrieval programs.
Please correct me if I am wrong.
Thanks |
Hi Jeevan,
You are absolutely right, after retrieval there is no need of issuing a commit statement.
Thanks
Saurabh |
|
Back to top |
|
|
|