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 |
What is tablespace?
how can i pull up a query which was previously stored in qmf
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
What is read-only cursor?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is schema in db2?
How to insert more than one record using insert?
What do you mean by storage group (stogroup)?
Can we insert update delete in view?
Write a query to extract first 5 characters of a name in the column Stud_Name?
How do I create a view in db2?
What is a cursor and what is its function?