Transaction control

When outputting a database, when all output is correctly completed, including the contents of SQL statement before beginning and SQL statement after ending normally, modifications are committed to the database.

If an error occurs during a conversion or when issuing SQL statements, the modifications are rolled back.

Note

In Oracle, when you issue DDL statements such as CREATE, DROP, RENAME, and ALTER, they are committed implicitly.Therefore, if the SQL statement before beginning field or the SQL statement after ending normally field is specified as a DDL statement, because the statement is committed immediately, the rollback is not performed.