Interested to Buy Any Domain ? << Click Here >> for more details...
What happens to a cursor after a commit?
- 3 Answers
- 10066 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / angoca
The commit will close the cursor if this last was not
declared with the 'with hold' option.
| Is This Answer Correct ? | 14 Yes | 0 No |
If the cursor is defined with "WITH HOLD" option, it will NOT closed even after the commit operation, else cursor will be closed.
| Is This Answer Correct ? | 0 Yes | 0 No |
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
how can you access index
Define data page.
How to rename a table in DB2 ?
What is the difference between Where and Having Clause
What is an asychronous write?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is a collection in db2?
What is difference between rollback and commit?
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
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
COBOL 
