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 |
Is db2 free?
Mention the location where the output received from explain statement is stored.
What can the SET option of the Repair Utility accomplish?
What is page size in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
When Can you be sure that a query will return only one row?
How many databases can be created inside an instance in db2 ?
What do you need to do before you do EXPLAIN ?
What happens to the PLAN if index used by it is dropped?
What is the use of with ur in db2?
What are some SQL aggregates and other built-in functions?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?