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

Post New Answer

More DB2 Interview Questions

How will you delete duplicate records from a table?

7 Answers   Google,


how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,


What is correlated subquery?

1 Answers  


What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,


What is null in db2?

0 Answers  






What is a collection in db2?

0 Answers  


What is runstats and reorg in db2?

0 Answers  


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


Which command is used to remove all rows from a table?

0 Answers  


what is datacom db?

2 Answers   CSC,


How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


Categories