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

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

Please Help Members By Posting Answers For Below Questions

What is cursor in dbms?

1069

What is query_cache_limit?

970

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

What parameters are used to control the free space in DB2?

1056

What is the syntax for creating a table in the db2 database?

1108

Are views updateable?

1161

What is the difference between bind and rebind in db2?

1453

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

1285

What is a system catalog table in db2?

1186

Why db2 is called db2?

1042

Where do you specify them?

1281

What is alias in db2?

1061

How to find the maximum value in a column in the db2 database?

1084

What is bind and rebind in db2?

1139

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

1051