EXEC SQL DECLARE X CURSOR FOR SELECT * FROM ABC FOR UPDATE OF <COLUMN

Suppose if I need to update a column, how you do that using
cursor?

Question Posted / sandy

2 Answers
8181 Views
Verizon, I also Faced
E-Mail Answers

Answer Posted / sandy

EXEC SQL DECLARE X CURSOR FOR
SELECT * FROM ABC
FOR UPDATE OF <COLUMN> ==>If we know the column we would
like to update.

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

i want to maintain uniqueness on pdf without make lf??????????

2099

Explain correlated sub-queries.

979

What is database reorganization?

1056

What is the difference between oracle and db2?

1033

What is a bind card?

1145

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

what is a corelated subquerry?

1065

What is dbrm? What it contains? When it will be created?

994

What is the picture clause of null indicator variable?

1083

Is ibm db2 free?

955

What is db2 bind process?

1183

How would you find out the total number of rows in a db2 table?

990

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1033

List out the three types of page locks that can be held.

1093

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2011