what is the use of commit ? and what is the syntax?
Answer Posted / 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 |
Post New Answer View All Answers
How to retrieve rows from a db2 table in embedded sql?
What is the difference between db2 and oracle?
Can you tell me how can you find out the # of rows updated after an update statement?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Define db2 and its databases?
Is db2 a mainframe database?
Explain the contention situations caused by locks?
Mention some fields that are a part of sqlca.
What is runstats db2?
How do I delete a table in database?
How to find the number of rows in db2 tables?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is explain plan in db2?
What is meant by explain?