Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of commit ? and what is the syntax?
- 2 Answers
- 10297 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 |
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is a host variable?
How does db2 sample database connect?
what is datacom db?
When is the authorization check on DB2 objects done - at BIND time or run time?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is a DB2 plan?
What is a data page?
What is the difference between drop table and delete table?
What is isolation level?
Can SQL statements/queries be included in a copybook?
COBOL 
