Stops the mapping run, and issues a specified error message to the log. When the

Data Integration Service

encounters an ABORT function, it stops transforming data at that row. It processes any rows read before the mapping run aborts. The

Data Integration Service

writes to the target up to the aborted row and then rolls back all uncommitted data to the last commit point.

Use ABORT to validate data. Generally, you use ABORT within an IIF or DECODE function to set rules for aborting a session.

Use the ABORT function for both input and output port default values. You might use ABORT for input ports to keep null values from passing into a transformation. You can also use ABORT to handle any kind of transformation error, including ERROR function calls within an expression. The default value overrides the ERROR function in an expression. If you want to ensure the session stops when an error occurs, assign ABORT as the default value.

If you use ABORT in an expression for an unconnected port, the

Data Integration Service

does not run the ABORT function.