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 the use of runstats in db2?
What is the latest version of ibm db2?
What will the COMMIT accomplish?
Give the COBOL definition of a VARCHAR field.
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
How can you display the current date & current time ?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What is image copy in db2?
How to check table size in db2 sap?
What does an outer join do?
List some fields from sqlca?
Why do we need reorg in db2?