EXEC SQL DECLARE STUDENT-CSR CURSOR SLECT NAME, CLASS, MARKS, STATUS FRO

what is the syntax for FOR UPDATE CLAUSE in cursor
declaration and how can u update using cursor? is it
possible to update multiple rows at a time.

Question Posted / vaneesh khurana

2 Answers
12384 Views
Syntel, I also Faced
E-Mail Answers

Answer Posted / vaneesh khurana

EXEC SQL
DECLARE STUDENT-CSR CURSOR
SLECT NAME, CLASS, MARKS, STATUS
FROM STUDENT-TABLE
WHERE ROLL-NO = :WS-ROLL-NO
FOR UPDATE OF STATUS
END-EXEC

EXEC SQL
UPDATE STUDENT-TABLE SET STATUS =:WS-STATUS
WHERE CURRENT OF STUDENT-CSR
END-EXEC

Is This Answer Correct ?

6 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the syntax for seeing the columns and data types of a table in the db2 database?

1145

Differentiate between cs and rr isolation levels? Where do you specify them?

1048

What is copy pending and check pending in db2?

981

How many databases are there?

1034

Explain the function done by data manager?

1257

What is bind and rebind in db2?

1124

Which components manage deadlocks in db2?

1052

What do you mean by between and in? Is between inclusive of specified range values?

1077

What is db2 look?

1007

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11663

What is the result of open cursor statement?

1071

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1221

What is a bind card?

1196

What is the use of dclgen in db2?

1059

What is table space in db2?

1003