Hi Dude,this is Ram.could any one tell me aboue CURRENT OF
clause in DB2.
Thanks in advance.......
Answers were Sorted based on User's Feedback
Answer / narayana reddy
current of is using in cursors.
whenever we want to update and delete table data after retrived
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kamlesh
Current of is used with cursors whenever v go for update in conjunction with for update of .
1.for update of in declare stmt
2.where current of in update query after fetching
| Is This Answer Correct ? | 1 Yes | 1 No |
How to find the number of rows in a db2 table?
What is bind and rebind in db2?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What is CHECK PENDING ?
Explain about dbrm.
What is null indicator in db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is DCLGEN ?
How many databases are there?
Comment whether the cursor is closed during commit or not.
How to check sequence on a table in db2?
what is difference between random and sequence file access