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 is with ur in db2?

884


what is a corelated subquerry?

738


Explain about cursor stability?

696


What is an instance database?

694


What are host variables in db2?

708






What is a bind in db2?

680


what is the responsibility of the construction superintendent

1744


What os does db2 run on?

651


How to restart a DB2 program?

1456


What is the difference between spufi and qmf?

716


What happens in bind step in a db2 program?

649


What is innodb buffer pool?

641


What is buffer pool and list some of them?

711


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2849


Is db2 a mainframe?

678