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

How to check table size in db2 sap?

583


How can the duplicate values be eliminated from db2 select?

633


Is db2 free?

684


What is with ur in db2?

761


What is copy pending status in db2?

638






List down the data types in the db2 database.

639


What does reorg do in db2?

578


What is precompiler in db2?

589


Which isolation level provides highest data integrity?

599


What is sqlca’s maximum length?

678


What is the use of runstats in db2?

579


Define data page.

634


What are the different types of base tables?

587


What is the use of with ur in db2?

619


What is a Foreign Key?

660