suppose in my table 10 rows are there , i want to update odd
rows salary as 90000 ? how u do it ? any one help me ? what
do we use here cursor-fetch or normal sql ?
Answer Posted / saurabh
It can be achieved using the scroll able cursor along with the Relative option while updating the queue.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is data manager?
What does db2 plan contain?
What is multi row fetch 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 is database alias db2?
What is the maximum number of columns in a db2 table?
What is the difference between using bind () and rebind () methods of naming class?
What is syscat in db2?
List out the three types of page locks that can be held.
How can we read records for specific member in CL? AND rpg?
Which isolation level provides highest data integrity?
What is load utility in db2?
How to connect to db2 database from windows command line?
What is db2 plan table?