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.
No Answer is Posted For this Question
Be the First to Post Answer
What is bind package and plan in db2?
How does DB2 use multiple table indexes?
What happens to the PLAN if index used by it is dropped?
When reorg is used?
what is consistency token
How to create a table using embedded sql?
pls explain the precompilation process of cobol-db2 pgm
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).
What does db2 blu stand for?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How could one combine a set of incremental image copies into a single copy?
What is a subselect? Is it different from a nested select?