Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 5 Answers
- 11000 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vaneeshkhurana
Basically we can create a structure where first fetch then
update the fetch 2 times and update once again fetch 2 times
and update once again fetch 2 times and update once... and
keep on fetching 2 times and updating it once till table
code 100 comes.
This will update only the odd rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between drop table and delete table?
How connect db2 database to datastage?
How do I delete a table in db2?
What is the role of union all and union
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is dbrm?
What is the syntax for creating a table in the db2 database?
How is a typical db2 batch pgm executed?
What is coalesce in db2?
What are packages in db2?
What are db2 tables?
What is ibm db2 database?
What is runstats db2?
What is a dbrm in db2?
What is dbrm library?
