|
|
| Author |
Message |
chengodan
Currently Banned
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. |
|
| Back to top |
|
 |
References
|
 Posted: Wed Aug 06, 2008 3:27 pm Post subject: Re: DB2 Related Query |
|
|
|
|
ashimer
Senior Member
Joined: 13 Feb 2004
Posts: 313
Location: Bangalore
|
|
| Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005
Posts: 179
Location: Copenhagen, Denmark
|
|
|
|
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. |
|
| Back to top |
|
|
| Moved: Wed Aug 06, 2008 9:38 pm by dick scherrer From DB2 to Interview Questions |
|
|
