Dataloader/MP Reference Manual

Specifying File-Related Options for DataLoader/MP
DataLoader/MP Reference Manual—424148-003
4-4
CSV
length
is the length of the field. length is required for CHAR and INT field types and is not
allowed for DATETIME, which is always eight bytes long. For INT type fields,
length must be one, two, four, or eight bytes.
The total translation information is a comma-separated list of these individual field
translation specifications, with one specification for each comma-separated data value,
in the order of the comma-separated data values. This list can be continued over
multiple lines by ending each line that is to be continued with an ampersand.
Example
This following example consisting of four input records (one translation specification
record and three data records) specifies an 11-byte character field, a 2-byte integer
starting on an even-byte boundary, a 4-byte integer starting on an even-byte boundary,
a 23-byte character field (that happens to contain a date-time value), a 4-byte
character field starting on the next byte boundary, and an 8-byte integer starting on a
boundary that is an even multiple of 4 bytes:
CHAR11 , 2:INT2, 2:INT4, &
CHAR23 , CHAR4 &
, 4:INT8
In the same file, this input is followed by comma-separated data records, with fields
corresponding to the specification. The data could look like this:
ABCDE, 1 , 2, 1943-11-29, 3, 4
"abcdef,ghi" , &
5, 6, '1996-02-12 11:47',&
7,8
'ABC''DEF' ,&
9, &
10, &
2001-5-1:9:30, &
"xy'z", &
13
There are several things to note in this example:
•
Blank lines in the data part of the file are skipped. You can put one or more blank
lines between records for better readability.
Blank lines may NOT appear between lines of the translation specification that is at
the beginning of the file. Blank lines may appear between the end of the translation
specification and the first data record.
•
Data records can be continued onto multiple lines by putting the ampersand (&}
character (or the CONTCHAR) at the end of each line of the record except the last.
The data record continuation is not related to any continuation used in the record
layout description. Blank lines may appear between the lines of a continued record