The default delimiter in a reject file is a comma (,). If you want to override this default delimiter, you can specify another delimiter in the REJECT_FILE_DELIMITER statement of the DBMOVER configuration file. You might want to specify an override delimiter if the data that is written to the database contains commas.

To use a semicolon (;) as the delimiter, enter the semicolon enclosed in double-quotation marks:

PowerExchange escapes a delimiter character that is part of the data by adding a backslash (\) before it. For example, if you use the default comma (,) delimiter, a comma in the data appears as follows:

Alternatively, if you use the semi-colon (;) as the column delimiter, a semicolon in the data appears as follows:

For more information about the REJECT_FILE_DELIMITER statement, see the

PowerExchange Reference Manual

.