In SQLServer there are statement "BEGIN TRANSACTION a" to begin transaction, does db2 have an any statement doing the same work? And statements "Commit" and "Rollback" is the same as those in SQLServer?
Thanks very much~
In DB2 a transaction is explicitly started with the execution of the first statement. You can also establish a savepoint (see SAVEPOINT statement in the reference) that allow you to roll back changes up to the savepoint and not to the beginning of the transaction.
COMMIT and ROLLBACK should function in the same manner as in SQL Server; however, I would check the SQL reference to confirm this.