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 are the various isolation levels possible?
What is reorg?
What is null indicator in cobol db2?
What are union and union all?
How is a typical db2 batch pgm executed?
Define sqlca.
What are host variables in db2?
How can deadlocks be resolved?
How to retrieve rows from a db2 table in embedded sql?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What does a deadlock mean in DB2?
What is database reorganization?
What is db2 look?
What is bind in db2?
How do I create a view in db2?