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 an instance database?

600

What is performance tuning db2?

620

Explain db2.

618

How to rename a table in DB2 ?

639

How can record locking be achieved in those DB2 versions which do not support it?

625

List down the data types in the db2 database.

633

What is dpf in db2?

666

How can you count the number of rows from a table tab?

637

What is declare cursor?

613

can all users have the privilage to use the sql statement select * (dml)?

642

What do you mean by commit and rollback?

594

How does coalesce work?

586

What is ibm db2 used for?

601

What is db2 instance?

592

Why cursor is used in db2?

575