Hi Dude,this is Ram.could any one tell me aboue CURRENT OF
clause in DB2.
Thanks in advance.......
- 2 Answers
- 4617 Views
- I also Faced
- E-Mail Answers
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 are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is copy book?
What is db2 plan table?
What is query_cache_limit?
How do you filter out the rows retrieved from a Db2 table ?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is a cursor?
pls explain the precompilation process of cobol-db2 pgm
can we update the table by using cursors can anyone post the query?
Highlight all the advantages that are attached to a package.
What information can you find in SYSIBM.SYSLINKS table?
COBOL 
