1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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 / krishna

Answers were Sorted based on User's Feedback



suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? a..

Answer / pandu

Hi Krishna, Actually your answer is ok but i have a small
doubt "he want to update odd rows salary as 9000" but in ur
answer i didn't find the odd rows.how will you divide that
table in odd rows and even rows? kindly tell me.

Is This Answer Correct ?    4 Yes 1 No

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? a..

Answer / 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

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? a..

Answer / saurabh

It can be achieved using the scroll able cursor along with the Relative option while updating the queue.

Is This Answer Correct ?    0 Yes 0 No

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? a..

Answer / 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

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? a..

Answer / krishna

Declare:
EXEC SQL
DECLARE CURSOR C1 FOR SELECT SAL FROM EMP FOR
UPDATE SAL
END-EXEC.
OPEN:
OPEN C1
FETCH:
PERFORM UNTILL SQLCODE=100
FETCH C1 INTO :SAL
UPDATE EMP SET SAL=9000 WHERE CURRENT OF C1
FETCH C1 INTO :SAL
END-PERFORM

Is This Answer Correct ?    10 Yes 13 No

Post New Answer

More DB2 Interview Questions

what is the difference between join and union?

4 Answers   IBM,

How to select the duplicate rows from a table?

4 Answers  

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

What is temporal table in db2?

0 Answers  




When do you specify the isolation level?

0 Answers  

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

What are PACKAGES ?

3 Answers  

What is access path in db2?

0 Answers  

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

What is isolation level in db2?

0 Answers  

Explain dclgen.

0 Answers  

For more DB2 Interview Questions Click Here
Categories