The size (in MB) of the internal buffer used for an export operation.

Default is 64.

The character used to delimit columns in the exported flat file. This parameter should only be set when MODE=1 (variable-length mode).

Default is | (vertical bar).

The end-of-line indicator in the exported flat file. This parameter is used only in fixed-length mode (MODE=0

)

. In variable-length mode (MODE=1), rows are always separated by the carriage return and line feed character combination (\r\n).

Default is \n.

The maximum size (in GB) for the temporary virtual file system created during the export operation.

Default is 8.

The way in which the exported data is written. There are two options: 0 (fixed-length mode) and 1 (variable-length mode). In fixed-length mode, each column has a fixed width; column values less than that width are padded with blank spaces. In variable-length mode, column values are separated from each other by a delimiter (set with the DELIMITER parameter); there is no space padding.

Default is 0 (fixed-length mode).

The character string that represents a null value in the exported flat file.

Default is NULL.

The directory where a temporary virtual file system will be created during the export operation.

Default is <DataVaultServiceDirectory>/temp.