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 happens in bind step in a db2 program?

1009

What are bind parameters in db2?

1094

What is db2 purescale?

1052

What is bind package and plan in db2?

1103

Why do chiropractors use drop table?

1162

What is explain in db2?

1078

What is dbrm in db2 database?

1189

What is meant by dclgen?

1170

Outputs of explain are with matchcols = 0. What does this signify?

1108

What is a plan and package in db2?

1150

What is difference between rollback and commit?

1203

How do I import a csv file into db2?

1039

Is db2 a mainframe?

1093

What is meant by union and union all?

1051

What is rebind in db2?

1117