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

is it compulsory commitment control in journal?

2008

What is precompiler in db2?

585

How to create db2 table in mainframe?

629

What is db2? Explain.

601

What is the cobol picture clause of the db2 data types date, time, timestamp?

611

How to fetch the last row from the table in SQL (db2)?

1035

What is the physical storage length of timestamp data type?

640

What is reorg?

617

How can we read records for specific member in CL? AND rpg?

228

What is cursor stability in db2?

805

If I have a view which is a join of two or more tables, can this view be updateable?

688

What is cursor with hold option in db2?

612

Which command is used to connect to a database in DB2 ? Give the Syntax.

599

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

1629

What is performance tuning db2?

615