Use the ABORT command in conjunction with the ON CONNECT/PACK command to stop the process, or with a stored procedure to stop a trigger.
Options
ON
The ON option is used in conjunction with the ON CONNECT/PACK command. It stops the connect or pack from being performed after the command file finishes.
TRIGGER
The TRIGGER option is used in a stored procedure to cancel the UPDATE, INSERT, or DELETE.
About the ABORT ON Command
The ABORT ON command is placed in the command file specified by the ON CONNECT/PACK command. It indicates that the CONNECT or PACK should not be performed after the command file finishes. For example, when using AUTOCHK with ON PACK to check the database for errors, use ABORT ON so the PACK is not performed if errors are found in the database.
Since a trigger runs a stored procedure before the row that triggered it is updated, inserted, or deleted, you can use the ABORT TRIGGER command to cancel the UPDATE, INSERT, OR DELETE.
