Dataloader/MP Reference Manual

Specifying File-Related Options for DataLoader/MP
DataLoader/MP Reference Manual—424148-003
4-5
DUMP
and are ignored. If you use the CONTCHAR, it replaces the ampersand (&). See
record 2.
•
CHAR fields do not have to be enclosed within quotes. The comma (or the
SEPCHAR) signals the end of the field. See record 1.
•
A CHAR field may be shorter than its specification. The value is left-justified and
blank-padded in the internal record. See record 1.
•
A comma (or the SEPCHAR) can be included in a CHAR field by enclosing the
entire field in quotes. See record 2.
•
The quotes used to enclose a CHAR field can be either single quotes (') or double
quotes ("). See record 2.
•
A quote may be included in a CHAR field by using two adjacent quotes of the type
that is used to enclose the field, or by enclosing the field in the other type of quote.
The included quote should not be doubled when the other type of quote is used to
enclose the field. See record 3.
For output, the output file must begin with a specification list like the one that starts
input CSV files. DataLoader/MP reads this specification list and uses it to format output
records into comma-separated value records appended to the file. The translation
works similarly to input, except that enclosing the field specifier in quotes of either type
causes the output field to be enclosed in quotes of the same type.
Example
In this example, CSV is used to control output:
>dataload -i=out(dump) &
-o=csvout(csv<sepchar=;,contchar=+ ,maxrecsize=85>)
The specification fields direct DataLoader/MP to replace the comma separation
character with a semicolon (;), to change the continuation character from an
ampersand (&) to a plus sign (+) and to put a maximum of 85 characters on a line.
In this example, CSV is used for output of status messages:
dataload -i=dtldata -o=outfile -s=500<CSV=csvstats>
500 input records are processed between status messages. The messages are in a
comma-separated values (CSV) format suitable for loading into a spreadsheet for
analysis or graphical display. The CSV status information is written to a file called
csvstats. See the -S parameter on page 3-8 for more details.
DUMP
The DUMP interpretation makes the file system treat the contents of the file as
hexadecimal and ASCII dumps of the actual records. It has the following format:
DUMP[<use>]