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
- 10640 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 ibm db2 database?
Is ibm db2 free?
What is null in db2?
What are types of indexes?
What do you mean by storage group (stogroup)?
How to create db2 table in mainframe?
What is the picture clause of null indicator variable?
Is db2 a mainframe?
What do you mean by cursor?
On which levels locks can be applied?
How and when does the db2 enforces the unique key?
What are the bind parameters ibm db2?
What is db2 instance?
What is the difference between drop table and delete table?
How to check table size in db2 sap?
