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 can you display the current date & current time ?
What is a view? Why use it?
What is dclgen in db2?
What does db2 plan contain?
What happens to the PLAN if index used by it is dropped?
What is a Foreign Key?
1 Answers Tavant Technologies, Zensar,
What is data manager?
is it possible to get -811 error when you use cursors. why?
What do you mean by commit and rollback?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What are union and union all?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?