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

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

1049

What is cursor in dbms?

1014

What is a db2 schema?

1186

How connect db2 database to datastage?

1196

Explain in detail about buffer manager and its functionalities?

1010

What is drop table?

967

Comment whether the cursor is closed during commit or not.

1047

What is runstats and reorg in db2?

1248

Is ibm db2 open source?

1027

Explain about rct in db2?

1056

Explain the benefits you can get from mainframe connect?

920

What is the maximum size of a char data type in db2?

974

Can you use max on a char column?

1040

What is dbrm? What it contains?

1121

What are the different types of base tables?

1040