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 is sqlca’s maximum length?
How to fetch the last row from the table in SQL (db2)?
What's The Percentage Free Space ?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
How to find the number of rows in a db2 table?
What is the picture clause of the null indicator variable?
What is with ur in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What db2 400?
What is DCLGEN ?
What are the functions of Bind?