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
What are the various isolation levels possible?
What is blu acceleration in db2?
What is performance tuning db2?
What is cursor in dbms?
What is host variable?
What is check constraint. Explain with example.
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to take backup of table in db2?
How to create backup table in db2?
Discuss about db2 bind?
What is reorg and runstats in db2?
What's The Percentage Free Space ?
How to find the number of rows in a db2 table?
What is coalesce in db2?