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 is difference between rollback and commit?

628


What is an instance in db2?

563


What is bufferpool in db2?

578


What is the difference between cursor and select statement?

613


What is db2 bind?

637






Is db2 free?

684


What types of tables are there in the db2 database?

552


Why db2 is called db2?

591


What os does db2 run on?

570


Name the lockable units in DB2?

663


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1595


How do I delete a table in db2?

645


Define data page.

630


What is a collection in db2?

579


Define db2.

671