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 |
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are concurrency issues?
How to check last update on table in db2?
Can one database have multiple instances?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
Can we update view in db2?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
In terms of DB2 indexing, what is the root page?
What are the various data types available in db2?
Explain what a plan is?
Explain what are the various isolation levels possible?