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

Which isolation level provides maximum concurrency?

1150

Explain the benefits you can get from mainframe connect?

970

How to execute stored procedures?

1125

Define check constraint.

1072

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1079

Explain dclgen.

1191

What is bind in db2?

1034

what is the sqlcode -501

13117

B37 abend during spufi?

1451

What is sqlca’s maximum length?

1176

What is host variable in db2 cobol?

1070

What is meant by dclgen?

1099

Can we insert update delete in view?

961

What is an instance in db2?

1029

Explain in brief how does db2 determine what lock-size to use?

1034