Answer Posted / anandrao
There are following possibilities to this issue to come,
1) Cursor is not declared in application program or
in stored procedure depending on where it is used.
Soln - Declare the cursor in application
program or in stored procedure depending on where it is
used.
2) Cursor spelling is not correct which you are
going to open or fetch.
Soln - Check the name used and correct.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain about open switch business continuity software?
Where can you declare a cursor in a cobol-db2 program?
What is page size in db2?
Why select is not preferred in embedded sql programs?
How to test SQL -911 error while developing COB-DB2 program
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Which are the db2 tools to protect integrity of the database?
What is view db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I delete a column in db2?
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.
How do we specify index to include or not during bind process.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Define check constraint.
What is commit in db2?