Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 9347 Views
- HeadStrong, I also Faced
- E-Mail Answers
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 |
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What db2 400?
How can you split a table in to exactly half?
What is buffer pool?
How can we define a table? How can we apply SEARCH ALL on it ?
What information is contained in a SYSCOPY entry?
What is DCLGEN ?
What is lock contention?
What are foreign keys in db2?
What is the syntax required for the creation of a cursor?
COBOL 
