Declare: EXEC SQL DECLARE CURSOR C1 FOR SELECT SAL FROM EMP FOR

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

5 Answers
10989 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What are the various data types available in db2?

1142

What is db2 catalog database?

1086

define clustering index.

1065

Are view updateable?

1085

What is db2 look?

1073

What is the physical storage length of time data type?

1175

What is alias in db2?

1108

Explain dclgen.

1266

What is the physical storage length of the data types date, time, and timestamp?

1136

What is the maximum number of columns in a db2 table?

1342

What are the 2 sqlcodes that are returned?

1230

What is the difference between bind and rebind in db2?

1505

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1786

How to take backup of table in db2?

1121

What is a page in db2?

1071