Suppose if I need to update a column, how you do that using
cursor?
Answer Posted / bobby
continuation of previous answer,
after cursor declaration, open the cursor and fetch the cursor. When the condition for update is satisified isue EXEC SQL UPDATE CURRENT OF.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is precompiler in db2?
How do I copy a table in db2?
How is deadlock resolved?
Mention the different locking levels that are available in db2.
What is phantom read in db2?
Which components manage deadlocks in db2?
What is cursor in dbms?
Can there be more than one cursor open for any program?
Define data page.
Which isolation level provides maximum concurrency?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is a Foreign Key?
Define declaration generator (dclgen).
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is db2 bind?