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
What is with ur in db2?
what is a corelated subquerry?
Explain about cursor stability?
What is an instance database?
What are host variables in db2?
What is a bind in db2?
what is the responsibility of the construction superintendent
What os does db2 run on?
How to restart a DB2 program?
What is the difference between spufi and qmf?
What happens in bind step in a db2 program?
What is innodb buffer pool?
What is buffer pool and list some of them?
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.
Is db2 a mainframe?