Use the ABORT
command in conjunction with the ON CONNECT/PACK command to abort the CONNECT
or PACK process, or with a stored procedure to stop a trigger.
Syntax:
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 command.
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 command.
