Stops the session, and issues a specified error message to the session log file. When the

PowerCenter Integration Service

encounters an ABORT function, it stops transforming data at that row. It processes any rows read before the session aborts and loads them based on the source- or target-based commit interval and the buffer block size defined for the session. The

PowerCenter Integration Service

writes to the target up to the aborted row and then rolls back all uncommitted data to the last commit point. You can perform recovery on the session after rollback.

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

PowerCenter Integration Service

does not run the ABORT function.