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 Runstats? Whem will u choose to runatats?
what is Static and dynamic linking
List some fields from sqlca?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
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?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
List out the three types of page locks that can be held.
How to find the maximum value in a column in the db2 database?
What does db2 mean?
what is the input to PLAN? what is the input to DBRM?
What is cursor?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?