Previous Topic: Add Database Exception Logic to an Entity Action StatementNext Topic: Add an Abort Transaction Action Statement


ABORT TRANSACTION Statement

The ABORT TRANSACTION statement terminates the execution of the procedure step, regardless if the ABORT TRANSACTION statement occurs within an action block or the procedure step itself. It causes an immediate exit and displays a fatal error message. That message may be either the last error message returned by a database exception or a user-supplied text expression.

In the following example, the last database error message displays:

WHEN database error 
ABORT TRANSACTION DISPLAYING last database error message 

In the following example, a user-supplied text expression displays:

WHEN database error 
ABORT TRANSACTION DISPLAYING concat ("A serious error occurred updating product ", product id)