I have a subprogram B calling from mainprogram A.I have
opened a cursor in A ,Can i fetch the same cursor in
subprogram B , If yes , Please explain the reason?
Answer / harsha
I feel yes, we can fetch the same cursor in the same
program.
Cursor can be closed in three ways.
1 When you explicitely close trhe cursor.
2 Issuing commit systement.
3 After execution of an application program.
In our situation, none of the above mentioned case is
getting true.
| Is This Answer Correct ? | 11 Yes | 2 No |
Request to database but database is not available so what is was abend is raised?
What is normalization and what are the five normal forms?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
Is ibm db2 free?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is db2 bind?
Is db2 relational database?
What is the difference between plan and package in db2?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What is the logical entity between plan and Package?
How to know the primary key of a table without defining the primary key in the table?