What is meant by AUTO COMMIT?
- 3 Answers
- 9162 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is the syntax for creating a table in the db2 database?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is meant by repeatable read?
How can record locking be achieved in those DB2 versions which do not support it?
when does the SQL statement gets executed when you use cursor in the application programming ?
How is deadlock resolved?
What is sqlcode -922 ?
How to find primary key of a table in db2?
What is drop table?
How do you insert a record with a nullable column?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
COBOL 
