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
How to execute stored procedures?
What is difference between alias and synonym in db2?
What type of database is db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Before you give the explain statement, what are the prerogatives?
What are the contents of dclgen?
What is cloudant database?
How do I copy a table in db2?
Mention the definition of cobol in varchar field.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How is a typical db2 batch pgm executed?
Are view updateable?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Who uses db2?
What is host variable?