Suppose if I need to update a column, how you do that using
cursor?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use cursor?

847


What is the max length of sqlca?

997


How to resolve deadlock issue

19093


What is temporal table in db2?

829


What is a db2 package?

816


What is the use of commit in db2?

837


Name the various locking levels available?

854


What os does db2 run on?

772


Explain dclgen.

957


Are views updateable?

856


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2998


What is isolation level in db2?

789


What is performance tuning db2?

864


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

891


What is the difference between using bind () and rebind () methods of naming class?

1111