Transaction Behavior in isql
Go Up to Command-line isql Tool
When you start
isql, InterBase begins a transaction. That transaction remains in effect until you issue a
ROLLBACK statement. You must issue a
ROLLBACK statement to end a transaction. Issuing one of these statements automatically starts a new transaction. You can also start a transaction with the
SET TRANSACTION statement.
isql uses a separate transaction for DDL statements. When these statements are issued at the
SQL> prompt, they are committed automatically as soon as they are completed. DDL scripts should issue a
COMMIT after every
CREATE statement to ensure that new database objects are available to all subsequent statements that depend on them. For more information on DDL statements, see the Data Definition Guide.