Specifies the directory where you want to write rejected rows and the corresponding error file. The ERRORFILE option is equivalent to the Reject Directory advanced target property.

Use the following format:

ERRORFILE=<Directory Location>

.

You can specify the absolute path or relative path for the directory. The error file path must not contain special characters.

If you specify an absolute path, for example,

Dir1/Dir2

, the agent creates the reject directory in the following path:

Dir1/Dir2

If you specify a relative path, for example,

/Dir1/Dir2

, the agent creates the reject directory in the following path:

<staging path>/Dir1/Dir2

If you do not specify the directory, the agent creates the reject directory in the following path:

<staging path>/Reject_<UUID Randomly Generated>

Specifies the maximum number of reject rows allowed in the load before the copy command is canceled. Each row that cannot be imported by the copy command is ignored and counted as one error. The MAXERRORS option is equivalent to the Reject Threshold advanced target property.

Use the following format:

MAXERRORS=max_errors

. For example,

MAXERRORS=20

.

Specifies the data compression method for the data. You can use only Gzip compression for CSV files.

The COMPRESSION option is equivalent to the Compression Format advanced target property.

Use the following format:

COMPRESSION='method'

. For example,

COMPRESSION='GZIP'

.

Specifies a single character that is used as the quote character in the CSV file.

The FIELDQUOTE option is equivalent to the Quote Character advanced target property.

Use the following format:

FIELDQUOTE='field_quote'

.

Specifies the field terminator that is used in the CSV file.

The FIELDTERMINATOR option is equivalent to the Field Delimiter advanced target property.

Use the following format:

FIELDTERMINATOR='field_terminator'

. For example,

FIELDTERMINATOR='ox1f'

.