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 |
What is a host variable?
What is Reorg Recovery? when will you run it?
what is the difference between where clause and having clause
How to see the structure of db2 table??
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
How to access db2 tables in mainframe?
How do you check for a null value in a db2 column?
How does cobol compile db2 program?
How do I copy a table in db2?
What is a DB2 bind?
What os does db2 run on?
how to execute qcmdexc in rpgle?plz write code also?