DB2 Related Query

chengodan · New User Joined: 18 Jun 2005 Posts: 1 Location: Chennai

Hi,

This is Cheng,

I wants to know the following usage,

1. For Update

2. Where current of

3. With Hold

I wants to know the Difference of these also.

ashimer · Posted: Wed Aug 06, 2008 6:12 pm Post subject:

http://ibmmainframes.com/manuals.php

vini_srcna · Posted: Wed Aug 06, 2008 7:50 pm Post subject:

All come in cursor declartion.

FOR UPDATE : It says which columns can be updated.

Where current OF : The latest row fetched using FETCH

WITH HOLD: says cursor not to be closed during COMMIT. It will still be closed if there are any ROLLBACKs.