What is meant by AUTO COMMIT?

Answers were Sorted based on User's Feedback



What is meant by AUTO COMMIT?..

Answer / s

When an application program executes successfully or when
you use SPUFI to issue SQL, a commit is issueed
automatically.

Is This Answer Correct ?    3 Yes 1 No

What is meant by AUTO COMMIT?..

Answer / m4io

"excutes" should be "ends"

thus :

When an application program ENDS successfully or when
you use SPUFI to issue SQL, a commit is issueed
automatically.

Is This Answer Correct ?    1 Yes 1 No

What is meant by AUTO COMMIT?..

Answer / mako

db2 list command option using c off
or
db2 list command option using c on

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

What are host variables in db2?

0 Answers  


What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  


How is a typical DB2 batch program executed ?

1 Answers  


I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,


How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  






How is the SUBSTR keyword used in sql?

1 Answers  


How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,


What is cursor?

2 Answers  


What is db2 optimizer?

0 Answers  


how can we retrieve the 100 records of the file ?

2 Answers   IBM,


What is reorg in DB2

3 Answers   Virtusa,


What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,


Categories