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
- 10644 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
What is the purpose of rollback and commit?
Mention data types used in db2 ?
Outputs of explain are with matchcols = 0. What does this signify?
Can we update view in db2?
What is isolation level in db2?
What is the max length of sqlca?
What is dbrm?
What is the physical storage length of timestamp data type?
Discuss about db2 bind?
What is the physical storage length of the data types date, time, and timestamp?
How can record locking be achieved in those DB2 versions which do not support it?
What is role in db2?
What happens in bind step in a db2 program?
How to find the number of rows in db2 tables?
What is sqlca?
