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.
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 the connection string to connect to the DB2 Database ?
Why db2 is called db2?
What is isolation level in db2?
What happens in bind step in a db2 program?
What does sqlcabc has?
What is buffer pool?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How would you find out the total number of rows in a db2 table?
What is runstats utility in db2?
What is dbrm library?
What does a deadlock mean in DB2?
How many databases are there?
What is the maximum number of columns in a db2 table?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do I start db2 in windows?