Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of commit ? and what is the syntax?
- 2 Answers
- 10175 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 |
Is ibm db2 open source?
Can you use max on a char column?
What do you mean by NOT NULL? When will you use it?
How to resolve -818 sql code in DB2?
What is a collection?
Define sqlca.
What are the various locking levels available?
What happens in bind step in a db2 program?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
How many Buffer pools are there in DB2 and what are they?
What is a db2 tablespace?
COBOL 
