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 Reorg Recovery? when will you run it?

2 Answers  


how to check the table is empty or not?

3 Answers   IBM,


What are foreign keys?

1 Answers  


Explain various types of locks in db2?

0 Answers  


How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,






how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,


Mention the definition of cobol in varchar field.

0 Answers  


What is the use of value function?

0 Answers  


What is the latest version of ibm db2?

0 Answers  


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  


What is the self-referencing constraint?

2 Answers  


Categories