WHAT IS MEANT BY COMMIT COMMAND?
Answers were Sorted based on User's Feedback
Answer / labog
Commit saves all the changes made to the database and
closes all Cursors opened except the Cursors with WITH HOLD
option.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / harsha
It is used to save the Logical Unit of Work(LUW) to
database.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santhosh
commit means saves the previous transaction done
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishnaveni
commit is used to save the previous dml(data manipulation
language ex:insert,upadte,.) statements
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shaikdada
I TOLD IT IS THE LAST EXECUTABLE STATEMENT OF COBOL DB2
PROGRAM.
Is This Answer Correct ? | 2 Yes | 3 No |
What is db2 bind?
When is the results table for the query in a DECLARE CURSOR statement created?
What is explain in db2?
What is the maximum length of sqlca?
Explain how can you do the explain of a dynamic sql statement?
What are the Isolation levels possible ?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the physical storage length of time data type?
Mention the definition of cobol in varchar field.
Mention the various locks that are available in db2.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
what is load and unload in db2