DataLoader/MX Reference Manual (G06.24+)

Specifying File-Related Options for DataLoader/MX
DataLoader/MX Reference Manual—525872-002
4-3
CSV
CSV[<spec>]
<spec>
can be any combination of the following, separated by commas and enclosed in
angle brackets:
Both input and output files for CSV must be either OSS files or Guardian EDIT files.
The TEXT interpretation is implied for OSS CSV files.
The record layout information necessary for the translation must be contained at the
beginning of each input file and must consist of a comma-separated list of translation
specifications, each corresponding to a field in the record.The syntax for these field
translation specifications is:
[alignment:]field-type[length]...
where
alignment
specifies that the start position of this field will be at the integral multiple of
alignment, as specified. The default value is one. The position of each record starts
at one.
SEPCHAR=charspec Changes the separator character from a comma to
another character. charspec can either be the new
separator character itself or its representation in
decimal. If specified, the new separator character
applies only to the data and not to the translation
specifications.
CONTCHAR=charspec Changes the continuation character from an
ampersand (&) to another character. charspec can
either be the new separator character itself or its
representation in decimal. If specified, the new
separator character applies only to the data and not to
the translation specifications.
MAXRECSIZE=num Changes the maximum line length from 239 to num.
Before adding a value to the current line,
DataLoader/MX checks to see whether the value will
make the line longer than the maximum length. If it
would make the line longer, DataLoader/MX writes the
current line and starts a new one before adding the
value to the line. Because a field must fit on a single
line, DataLoader/MX might be forced to create an
output line longer than specified. This option is valid
only for output.