Dataloader/MP Reference Manual

Specifying File-Related Options for DataLoader/MP
DataLoader/MP Reference Manual—424148-003
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 edit files.
For input, 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 as follows:
[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 1. The position of each record starts at
1.
field-type
is CHAR, INT, or DATETIME.
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/MP checks to see whether the value will
make the line longer than the maximum length. If it
would make the line longer, DataLoader/MP 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/MP might be forced to create an
output line longer than specified. This option is valid
only for output.