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
- 10836 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / harsha
The first answer is correct. It has a logic to select only
ODD rows(look at the two fetch statements).
Another logic to select only ODD rows.
SELECT SAL FROM EMP WHERE MOD(SAL,2)=1
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Why cursor is used in db2?
What is the information associated with sysibm.syslinks table?
Which component is responsible for processing sql statements and selecting access paths?
What is runstats utility in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What is rebind in db2?
What is db2 bind?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Explain the function of data manager.
What is ibm db2 connect?
What do you mean by between and in? Is between inclusive of specified range values?
Define buffer pool.
How to connect to db2 database from windows command line?
How do I delete a table in db2?
What is db2 bind process?
