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


Please Help Members By Posting Answers For Below Questions

What are the various isolation levels possible?

895


What is reorg?

884


What is null indicator in cobol db2?

819


What are union and union all?

772


How is a typical db2 batch pgm executed?

912


Define sqlca.

889


What are host variables in db2?

844


How can deadlocks be resolved?

765


How to retrieve rows from a db2 table in embedded sql?

1044


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?

2190


What does a deadlock mean in DB2?

897


What is database reorganization?

872


What is db2 look?

826


What is bind in db2?

819


How do I create a view in db2?

823