Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of commit ? and what is the syntax?
- 2 Answers
- 10325 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 is temporal table in db2?
how to copy the host variables from ps file into cobol program other than include statement
What is DCLGEN ?
What is host variable?
What is QUIESCE?
What is a buffer pool?
what is load and unload in db2
Where besides the DB2 catalog is database object information stored by DB2?
What is the maximum number of columns in a db2 table?
What are iseries servers?
What is a root page?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
COBOL 
