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
Why do we use cursor?
What is the max length of sqlca?
How to resolve deadlock issue
What is temporal table in db2?
What is a db2 package?
What is the use of commit in db2?
Name the various locking levels available?
What os does db2 run on?
Explain dclgen.
Are views updateable?
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.
What is isolation level in db2?
What is performance tuning db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the difference between using bind () and rebind () methods of naming class?