IIF( TOTAL_SALES>0, TOTAL_SALES, ERROR ('Negative Sale'))

Constant value or expression.

The constant value or expression overrides the ERROR function in the output port expression.

For example, if you enter ‘0’ as the default value, the Integration Service overrides the ERROR function in the output port expression. It passes the value 0 when it encounters an error. It does not skip the row or write ‘Negative Sale’ in the log.

ABORT.

The ABORT function overrides the ERROR function in the output port expression.

If you use the ABORT function as the default value, the Integration Service aborts the when a transformation error occurs. The ABORT function overrides the ERROR function in the output port expression.

ERROR.

If you use the ERROR function as the default value, the Integration Service includes the following information in the log:

Error message from the default value

Error message indicated in the ERROR function in the output port expression

Skipped row

For example, you can override the default value with the following ERROR function:

ERROR('No default value')

The Integration Service skips the row, and includes both error messages in the log.

 TE_7007 Transformation Evaluation Error; current row skipped...
 TE_7007 [<<Transformation Error>> [error]: Negative Sale
... error('Negative Sale')
]
Sun Sep 20 13:57:28 1998
TE_11019 Port [OUT_SALES]: Default value is: ERROR(<<Transformation Error>> [error]: No default value
... error('No default value')