Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of commit ? and what is the syntax?
- 2 Answers
- 10289 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
Why do we need reorg in db2?
Where do you specify them?
Can we insert update delete in view?
What is collection in db2 bind?
What is explain in db2?
What is rct?
can all users have the privilage to use the sql statement select * (dml)?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to check table size in db2 sap?
Explain db2.
What is package in db2 mainframe?
Define buffer pool.
What is difference between rollback and commit?
What is clone table?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
