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
What is copy pending and check pending in 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 .....
What r the comman abends in db2, jcl and cobol???????
What is dbrm? What it contains?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Explain dclgen.
What is ibm db2 connect?
Is schema the same as database?
What is view db2?
What is an instance database?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Where do you specify them?
How can you count the number of rows from a table tab?
What is ibm db2 database?