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 are db2 tables?
How is the SUBSTR keyword used in sql?
What are common abends
How to define the data items to receive the fetch items for the SQL?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
Are view updateable?
What is the use of reorg in db2?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
How can you count the number of rows from a table tab?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
why we go for SPUFI for creating tables or for sql queries?
What will happen, while trying to close the closed cursor.