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 |
Which component is responsible for processing sql statements and selecting access paths?
Mention the various locks that are available in db2.
What is meant by index cardinality?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is access path in db2?
What is a synonym? How is it used?
What is the syntax for FETCH in DB2 ?
can i code union in cobol-db2 pgm ?
What is db2 optimizer?
What will the DB2 optimizer do?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What does reorg do in db2?