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
- 11007 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 image copy in db2?
What is a bind card?
What is bind plan?
What is coalesce in db2?
What is db2 instance?
What is runstats and reorg in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the syntax for creating a table in the db2 database?
What are bind parameters in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is release/acquire in bind?
What is package in cobol db2?
What is the use of with ur in db2?
How to execute stored procedures?
How do you select a row using indexes in db2?
