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 / 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 |
What is a view? Why use it?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
what is SMP/E? and what are the major steps of it? thanks...
what is consistency token
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is CHECK PENDING ?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What is IMAGECOPY ?
What happens to a cursor after a commit?
What is usage pointer in cobol?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
what's the error code for Unique Index Violation?