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?



I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same..

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

Post New Answer

More DB2 Interview Questions

What is buffer pool?

0 Answers  


How connect db2 database to datastage?

0 Answers  


What is the difference between bind and rebind in db2?

0 Answers  


Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,


what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,






What is an asychronous write?

1 Answers  


What is dbrm?

0 Answers  


What are the contents of a DCLGEN?

4 Answers   MetLife,


what is plan? is plan executable or package?

4 Answers  


What is lock escalation in db2?

0 Answers  


Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,


How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,


Categories