Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF
clause in DB2.
Thanks in advance.......
- 2 Answers
- 5334 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 is the usage of open cursor command?
What is the use of commit in db2?
What is the FREE command?
What is db2?
explain about index with examples
What do you need to do before you do EXPLAIN?
What is universal database?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
how to fetch first 100 rows in db2
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What os does db2 run on?
What should be specified along with a cursor in order to continue updating process after commit?
COBOL 
