what is the use of commit ? and what is the syntax?
Answer Posted / yuvaevergreen
Commit statement is an explicit way of mentioning that
>>any changes should be committed to the object.
>>any locks to be released from the particular object
(except WITH HOLD cursor)
I hope syntax should be
EXEC SQL
COMMIT
END-EXEC.
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is table space in db2?
What is difference between rollback and commit?
Why do chiropractors use drop table?
Comment whether the cursor is closed during commit or not.
What is buffer pool?
Define check constraint.
Is it possible using max on a char column?
Mention the different locking levels that are available in db2.
What is ibm db2 client?
What is dbrm in db2 database?
Explain the function done by data manager?
what is the role of the cursor in db2?
What is the role of data manager in the db2 database?
When reorg is used?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?