I feel yes, we can fetch the same cursor in the same program. Cursor can

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?

Question Posted / harsha

1 Answers
9424 Views
HeadStrong, I also Faced
E-Mail Answers

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

Define db2 and its databases?

1044

What is a collection in db2?

1026

What is the difference between cursor stability and repeatable read isolation levels?

1163

What is an instance in db2?

1024

Is ibm db2 free?

998

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1073

What is schema in db2?

1014

How do I delete a table in db2?

1055

Define data page.

1053

What is performance tuning db2?

1056

What is db2 plan table?

1041

What is view db2?

1061

What is the maximum number of columns in a db2 table?

1273

What is dbrm library?

1043

What is buffer pool in the db2 database?

1083