Options for running statements in the SQL and XQuery editor

In the Configuration page of the editor, specify how statements are handled when statements are run successfully or when an error occurs. These options are dependent upon the type of environment you choose in the Run method field.
The following table describes how statements are handled when the statements are run successfully or encounter errors in a command line processor environment:
On Success On Error Result
Commit after each statement Continue If a statement is successful, it is committed to the specified database. If an error occurs, the next statement will run.
Commit after each statement Stop If a statement is successful, it is committed to the specified database. If an error occurs, the script will stop running.
User managed commit Continue If a COMMIT statement is included in the script, the statement is committed at that point. If an error occurs, the next statement will run.
User managed commit Stop and Commit If a COMMIT statement is included in the script, the statement is committed at that point. If an error occurs, the script will stop running, and any statements that have run are committed to the specified database.
The following table describes how statements are handled when the statements are run successfully or encounter errors in a JDBC environment:
On Success On Error Result
Commit after each statement Continue If a statement is successful, it is committed to the specified database. If an error occurs, the next statement will run.
Commit after each statement Stop If a statement is successful, it is committed to the specified database. If an error occurs, the script will stop running.
Commit on completion of script Continue If all of the statements in the script are successful, all statements are committed to the specified database. If an error occurs, the next statement will run, and all successful statements are committed to the specified database.
Commit on completion of script Stop and Commit If all of the statements in the script are successful, all statements are committed to the specified database. If an error occurs, the script will stop running, and any statements that were successfully run are committed to the specified database.
Commit on completion of script Stop and Roll Back If all of the statements in the script are successful, all statements are committed to the specified database. If an error occurs, the script will stop running, and all successful statements are rolled back.
Roll Back on completion of script Continue If all of the statements in the script are successful, all statements will be rolled back. If an error occurs, the next statement in the script will run, and any successful statements are rolled back.
Roll Back on completion of script Stop and Roll Back If all of the statements in the script are successful, all statements will be rolled back. If an error occurs, the script will stop running, and all successful statements are rolled back.

Feedback