Difference between current of and update of in DB2

spriya · New User Joined: 06 Oct 2005 Posts: 42

hi
can any body tell wat is the difference between current of and update of
in db2

narenndra_tallapireddy · New User Joined: 12 Jul 2005 Posts: 5

hi,

we can use current of when we are deleting a single row using a cursor.
for update of is used only for updating only columns that u need to update.

i think this will clear your doubt.

corrections are always acceptable.

regards,
narendra

sunnybunny · New User Joined: 29 Nov 2005 Posts: 49

Hi Narendra,

By using CURRENT OF we can do both update and delete. CURRENT OF is used to update or delete current row. Whereas UPDATE OF is used to just lock the columns which we want to update.

Thanks,
Sunny.