what is the use of commit ? and what is the syntax?
- 2 Answers
- 9713 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 cascading rollback?
On which levels locks can be applied?
Can you use max on a char column?
How do I add a column to an existing table in db2?
What do you mean by rollback?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to find schema of a table in db2?
How to find the number of rows in a db2 table?
List down the data types in the db2 database.
How do I import a csv file into db2?
What is load utility in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is db2 stogroup?
How to execute stored procedure in db2 command editor?
Name the lockable units in DB2?
