what is the use of commit ? and what is the syntax?
- 2 Answers
- 9231 Views
- Deloitte, I also Faced
- E-Mail Answers
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 nvl in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the default page size of buffer pools?
How can you count the number of rows from a table tab?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is table space in db2?
When reorg is used?
How do I add a column to an existing table in db2?
What is the physical storage length of timestamp data type?
What is db2 stogroup?
What are concurrency issues?
What is the difference between cursor stability and repeatable read isolation levels?
What is dbrm in db2 database?
What is role in db2?
Define sqlca.
