Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of commit ? and what is the syntax?
- 2 Answers
- 10194 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 the purpose of rollback and commit?
How does a cursor work?
What is a correlated sub query?
what is the maximum number of tables that can be joined ?
how to get duplicate records from tables?write qurey for this?
how can i pull up a query which was previously stored in qmf
What is the difference between cursor and select statement?
What is an asychronous write?
How many Buffer pools are there in DB2 and what are they?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
When can an insert of a new primary key value threaten referential integrity?
How to get the ddl of a table in db2?
COBOL 
