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


Please Help Members By Posting Answers For Below Questions

What are the various isolation levels possible?

835


What is blu acceleration in db2?

806


What is performance tuning db2?

818


What is cursor in dbms?

809


What is host variable?

789


What is check constraint. Explain with example.

838


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?

2265


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

845


How to take backup of table in db2?

789


How to create backup table in db2?

839


Discuss about db2 bind?

852


What is reorg and runstats in db2?

923


What's The Percentage Free Space ?

958


How to find the number of rows in a db2 table?

834


What is coalesce in db2?

860