REJECT

The REJECT function returns the content of an object in error as a text item. Use REJECT in conjunction with the restart attribute. You can use the REJECT function in map rules only, not in component rules.

See the schema designer and map designer documentation for information about the restart attribute.

Syntax:
REJECT (series-object-expression)
Meaning:
REJECT (series_to_look_for_bad_objects)
Returns:
A series text item

REJECT 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.

Related functions

  • CONTAINSERRORS
  • ISERROR
  • VALID

Feedback