what is the use of commit ? and what is the syntax?
- 2 Answers
- 9681 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / p.shravani
commit is a command.It is used to make the changes permanent
on the storage when the transaction is successfully
processed or execute.
syntax
exec sql
commit
end-exec.
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / 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 |
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is buffer pool and list some of them?
Is db2 a mainframe?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the role of data manager in the db2 database?
What is difference between alias and synonym in db2?
What is a Resource Control Table(RCT)? Describe its characteristics.
what is plan? is plan executable or package?
how to resolve -811 sqlcode .give clear explaination
How does cobol compile db2 program?
What is a lock?
COBOL 
