Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor stability?
- 1 Answers
- 5426 Views
- I also Faced
- E-Mail Answers
Answer / s
The lock is held as long as the cursor is positioned on the
page or row. The lock is released once the cursor moves to
another page or row.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What does reorg do in db2?
What is collection in db2 bind?
Compare a subselect to a join?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What is a cursor?
Can we delete records from view?
How does DB2 use multiple table indexes?
On the create tablespace, what does the CLOSE parameter do?
Explain various types of locks in db2?
COBOL 
