what is the use of commit ? and what is the syntax?
- 2 Answers
- 9442 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 |
What if we fail to give values in columns declared as NOT NULL ?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
wht displays the number of times a query modified ?
How do you eliminate duplicate values in db2?
What is the maximum size of a char data type in db2?
What is a storage group (stogroup)?
What is buffer pool?
how to resolve -811 sqlcode .give clear explaination
What is concurrency?
How to handle null values in db2
How to find primary key of a table in db2?
COBOL 
