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

Explain how can you do the explain of a dynamic sql statement?

649


What is a dbrm in db2?

574


How to find the number of rows in db2 tables?

607


What action db2 takes when a program aborts in the middle of a transaction?

652


How do I import a csv file into db2?

556






How would you find out the total number of rows in a db2 table?

573


How does a cursor work?

554


What are foreign keys in db2?

614


What is ibm db2 connect?

570


What is db2? Explain.

601


What is database manager in db2?

547


What is deadlock in db2?

577


what are bind concepts in db2 cobol?

645


How to access db2 tables in mainframe?

611


How to find the number of rows in a db2 table?

644