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
12407 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

Which component is responsible for db2 startup and shutdown?

1029

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1099

What is the difference between spufi and qmf?

1117

Mention data types used in db2 ?

1147

What are union and union all?

975

Explain packages.

1102

What is data manager?

1040

How do I add a column to a table in db2?

1098

What is meant by union and union all?

1004

What is the maximum No of rows per page?

1059

Is db2 a database?

955

What is db2 and what is the use of db2 optimizer?

1047

What is release/acquire in bind?

1098

What's The Percentage Free Space ?

1219

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2079