Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

ABORT

ABORT

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.
The
PowerCenter Integration Service
handles the ABORT function and the Abort command you issue from the Workflow Manager differently.

Syntax

ABORT(
string
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
string
Required
String. The message you want to display in the session log file when the session stops. The string can be any length. You can enter any valid transformation expression.

Return Value

NULL.

0 COMMENTS

We’d like to hear from you!