Interested to Buy Any Domain ? << Click Here >> for more details...
How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
- 2 Answers
- 9597 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
If you like the cursor maintain the position even after the
commit, CURSOR is defined WITH HOLD.
| Is This Answer Correct ? | 4 Yes | 0 No |
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is the difference between base table and view?
What is a clustering index?
What are the two types of logging in the db2 database? Explain them.
How many sub queries can you combine together ?
What is COPY PENDING status?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
Explain in brief how does db2 determine what lock-size to use?
What is null indicator in cobol db2?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is buffer pool in the db2 database?
COBOL 
