Hi Dude,this is Ram.could any one tell me aboue CURRENT OF
clause in DB2.
Thanks in advance.......
Answer Posted / 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 |
Post New Answer View All Answers
How can you quickly find out the # of rows updated after an update statement?
What is catalog database in db2?
How do I optimize a query in db2?
What is runstats and reorg in db2?
How do I delete a column in db2?
How connect db2 database to datastage?
What is reorg and runstats in db2?
List out the three types of page locks that can be held.
Is it possible using max on a char column?
How do you select a row using indexes in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is difference between isnull and coalesce?
What is the default page size of buffer pools?
How do you stop a db2 database in linux?
What is with ur in db2?