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 bufferpool in db2?
what is the soft code for deadlock ?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What keyword does an SQL SELECT statement use for a string search?
Which are the db2 tools to protect integrity of the database?
Is db2 a mainframe database?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What are db2 tables?
Explain in detail about buffer manager and its functionalities?
What is the difference between group by and order by?