The first answer is correct. It has a logic to select only ODD rows(look

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 ?

Question Posted / harsha

5 Answers
10758 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

Please Help Members By Posting Answers For Below Questions

What is catalog database in db2?

1145

What is the syntax for FETCH in DB2 ?

1187

What is the advantage in De-normalizing tables in DB2?

1152

what is db2 restart?

2135

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2051

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1263

Explain packages.

1094

Explain about rct in db2?

1091

Mention the location where the output received from explain statement is stored.

1109

Why cursor is used in db2?

1022

What is dclgen in db2?

1114

What is the difference between db2 and oracle?

1108

What is bind plan?

1036

What is a db2 tablespace?

1046

What is bind package and plan in db2?

1043