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


Please Help Members By Posting Answers For Below Questions

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2518


What are host variables in db2?

798


What is dpf in db2?

853


How to create db2 table in mainframe?

847


What is the max length of sqlca?

959


What is the usage of open cursor command?

774


What is bind plan?

796


Define buffer pool.

795


What is collection in db2 bind?

765


How can you find out the # of rows updated after an update statement?

851


Mention the downsides of page level lock.

909


What is db2 bind?

807


How to view db2 table structure?

790


How many databases can be created inside an instance in db2 ?

806


What is db2 purescale?

757