Reference Manual

Back Next

REJECT_FILE_DELIMITER Statement

The REJECT_FILE_DELIMITER statement defines the character that PowerExchange uses as the default delimiter character in a reject file.

This statement is useful if the data contains commas. For more information about reject files, see the PowerExchange Bulk Data Movement Guide
.

All

REJECT_FILE_DELIMITER={character|,}

For the character variable, enter a single character. Default is the comma (,) character.

If the delimiter character must be the semicolon (;) character, enclose it in double quotation marks, as follows:

REJECT_FILE_DELIMITER=”;”