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

How do I create a view in db2?

596


What is ibm db2 connect?

567


What is a plan and package in db2?

609


What is syscat in db2?

570


How can you count the number of rows from a table tab?

627






Can there be more than one cursor open for any program?

652


Explain the contention situations caused by locks?

584


What is with ur in db2?

744


Explain the contents that are a part of dclgen.

651


What is cursor stability in db2?

798


What is the role of data manager in the db2 database?

634


What action db2 takes when a program aborts in the middle of a transaction?

649


What is db2 look?

565


How does db2 sample database connect?

563


What is the picture clause of null indicator variable?

684