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
- 9556 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How to check last update on table in db2?
How to restart a DB2 program?
Mention the location where the output received from explain statement is stored.
Which component is responsible for processing sql statements and selecting access paths?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How to find schema of a table in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is sqlca’s maximum length?
What do you mean by storage group (stogroup)?
What is a db2 tablespace?
What is dbrm library?
How is a typical db2 batch pgm executed?
What is a trigger in the db2 database?
What is database alias db2?
