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
- 10797 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
List out the buffer pools in db2
What is the syntax for creating a table in the db2 database?
What is the use of commit in db2?
How to rename a table in DB2 ?
What do you mean by storage group (stogroup)?
Is db2 a database?
What is bind and rebind in db2?
What does db2 mean?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What does sqlcabc has?
What is explain plan in db2?
What is cloudant database?
List out the three types of page locks that can be held.
Which component is responsible for db2 startup and shutdown?
Mention the various locks that are available in db2.
