DataLoader/MX Reference Manual (G06.24+)

Specifying File-Related Options for DataLoader/MX

DataLoader/MX Reference Manual—525872-002

4-4

CSV

field-type

is CHAR, INT, or DATETIME.

length

is the length of the field. length is required for CHAR and INT field types but 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 translation information consists of 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 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 also contains 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", &

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 cannot appear between lines of the translation specification that is at

the beginning of the file. Blank lines can appear between the end of the translation

specification and the first data record.