what is the syntax for FOR UPDATE CLAUSE in cursor
declaration and how can u update using cursor? is it
possible to update multiple rows at a time.
- 2 Answers
- 11708 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / vaneesh khurana
If one wants to update multiple rows simply write a querry,
instead of using cursor.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is universal database?
What is difference between rollback and commit?
What is runstats utility in db2?
What is db2 connect?
What is the purpose of using commit?
Can we insert update delete in view?
What is the syntax for FETCH in DB2 ?
Why db2 is called db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
List some fields from sqlca?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How can you do the explain of a dynamic sql statement?
what is utility for parm lib
What is access path in db2?
How many databases can be created inside an instance in db2 ?
