Is it required to do a commit for retreival program

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........

William Thompson · Posted: Tue Jan 16, 2007 5:53 pm Post subject:

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?

vickyarora81 · New User Joined: 20 Feb 2006 Posts: 4

Hi William,

Thanks for the reply but I asking in regard to IDMS.....

William Thompson · Posted: Tue Jan 16, 2007 6:33 pm Post subject:

Good point,

That's what I get for not looking at which forum the thread is in......

jeevankumar

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

tosaurabh20 · New User Joined: 08 Jun 2007 Posts: 26 Location: Noida