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 |
What is null in db2?
What are db2 tables?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is a view? Why use it?
What is reorg and runstats in db2?
what is the difference between declaring the cursor in WS section and Procedure division?
What is pagespace?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What are delete-connected tables?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What is RUNSTATS?