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
12561 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 rct?

1285

How to rename a table in DB2 ?

1142

What is ibm db2 client?

1001

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1145

What is db2 purescale?

1050

How do I delete a column in db2?

1152

What are packages in db2?

1071

Explain about rct.

1129

What is meant by dclgen?

1169

What db2 400?

1249

What is the reason behind not using select * in embedded sql programs?

1161

How does db2 sample database connect?

1077

What is the difference between dbm cfg and db cfg file in db2 ?

1589

What are the uses of db2 optimizer?

1350

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1211