DB2: A calls B once sucessfull and second time when it
calls says curson is open why is it so?

Answer Posted / sunil

while declearing the cursor in working-storage
section 'with hold' option is used due that's why cursor
remains open while next processing

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the rules for db2 programming?

643


Why db2 is called db2?

595


Which are the db2 tools to protect integrity of the database?

692


How is a typical db2 batch pgm executed?

642


What is a cursor in programming?

596






What is dbrm? When it will be created?

600


How can you do the explain of a dynamic sql statement?

637


What is drop table?

584


How do I add a column to a table in db2?

620


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

730


define clustering index.

617


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

748


What is runstats and reorg in db2?

800


What is the latest version of ibm db2?

740


Which component is used to execute the sql statements?

621