what is the use of commit ? and what is the syntax?
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 |
how to check the table is empty or not?
Differentiate between cs and rr isolation levels? Where do you specify them?
How to see the structure of db2 table??
why we create view.
can we view the access paths created by dbrm ? how ? thx
What is a DBRM, PLAN ?
Can a array declared with an index be displayed(readable format) in spool?
What is an intent lock?
How to resolve -502 sql code in DB2?
What information is used as input to the bind process?
What is the function of logging in the db2 database?
When is the results table for the query in a DECLARE CURSOR statement created?