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

What is a DB2 catalog?

2 Answers  


How can we read records for specific member in CL? AND rpg?

0 Answers  


What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,


How does DB2 use multiple table indexes?

1 Answers  


How do we specify index to include or not during bind process.

0 Answers   Satyam,


What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  


What are the isolation levels possible ?

3 Answers  


List down the types of triggers in the db2 database?

0 Answers  


which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,


Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


Why do chiropractors use drop table?

0 Answers  


Categories