Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of commit ? and what is the syntax?
- 2 Answers
- 10331 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 read-only cursor?
What is the difference between drop table and delete table?
Explain about cursor stability?
how to u check the query is executing or not ?where will u check for sqlcode ?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is a precompiler?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
How are write I/Os from the buffer pool executed?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
What is image copy in db2?
COBOL 
