Interested to Buy Any Domain ? << Click Here >> for more details...
DB2: A calls B once sucessfull and second time when it
calls says curson is open why is it so?
- 1 Answers
- 6070 Views
- IBM, I also Faced
- E-Mail Answers
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 does db2 mean?
What is coalesce in db2?
Can we delete records from view?
What is db2 optimizer?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is db2 command?
what is the role of the cursor in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Where can you declare a cursor in a cobol-db2 program?
Is it possible using max on a char column?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Is db2 free?
Mention the location where the output received from explain statement is stored.
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.
