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 host variable?

683

What is sqlca’s maximum length?

792

Explain the contents that are a part of dclgen.

743

Explain about rct in db2?

751

How do I delete a column in db2?

755

What is temporal table in db2?

690

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11170

What is the result of open cursor statement?

716

Mention the different locking levels that are available in db2.

730

what is the sqlcode -501

11707

What is with ur in db2?

884

What is db2 instance?

686

What is a trigger in the db2 database?

669

What is a db2 cursor?

712

How will you return the number of records in table?

595