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 Posted / 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 |
Post New Answer View All Answers
What is database reorganization?
What is image copy in db2?
What is the difference between drop table and delete table?
Define db2.
How to create backup table in db2?
is it compulsory commitment control in journal?
what is db2 restart?
B37 abend during spufi?
What is multi row fetch in db2?
What is db2 purescale?
what is diffrence b/w file-aid tool and file-aid utility???
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Explain correlated sub-queries.
Describe major components of db2?