Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference REJECT
Functions and Expressions Reference Guide
170
REJECT
The REJECT function returns the content of an object in error as a text item.
Syntax
REJECT (series-object-expression)
Meaning
REJECT (series_to_look_for_bad_objects)
Returns
This function returns a series-text-item.
Evaluates to a series of text items consisting of all the input series members in
error.
Examples
REJECT (Record:File)
This example extracts all Records that are in error.
IF (COUNT (REJECT (Msg IN Batch))) = 0, "OK", "ERROR")
In this example, the total number of invalid (rejected) Msg objects is counted.
If the total number of invalid Msg objects is equal to zero, it indicates that
there were no invalid Msg objects counted and a message of OK results.
Otherwise, a message of ERROR results.
Uses
Use in conjunction with the restart attribute. For information about the restart
attribute, see the Type Designer Reference Guide and the Map Designer
Reference Guide.
The
REJECT function can only be used in a map rule. It cannot be used in a
component rule.
Related Functions
CONTAINSERRORS, ISERROR, VALID