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 copy book?
What are the various data types available in db2?
How to resolve -504 sql code in DB2?
Is db2 a mainframe database?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is a db2 collection?
What is a SELECT statement?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What is the cascade rule and how does it relate to deletions made with a subselect?