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

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


What do you mean by commit and rollback?

0 Answers  


When is the skeleton cursor table created?

1 Answers  


How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,






What is blu acceleration in db2?

0 Answers  


What is null indicator in db2?

0 Answers  


What is the function of the Data Manager?

2 Answers  


Explain about cursor stability?

0 Answers  


When reorg is used?

0 Answers  


What is an intent lock?

3 Answers  


Can we install 2 different versions of Db2 on same mainframe?

3 Answers  


Categories