<fixed-width-file>

Fields in the data file are fixed in width.

Fixed Width File

start-row

Row from which to start loading. For example, start-row="2" tells the loader to skip the first row. (Default=1)

end-row

Row after which to stop loading. (Default=end of file or first empty row)

treat-missing-trailing-fields-as-null

Whether to treat missing trailing fields (files with fewer fields than defined in the load specification) as null values instead of errors. (Default=false)

charset

Character set used by the data file. Generally defined only for files that use a character set different from that of the computer on which the loader is running. (By default, the character set is not specified.)

row-increment

Number of rows between each record in the file. Generally defined only for files containing multiple data pivots. (Default=1)

widths

Required:. Widths of the fields in the data file. For example, width="10 18 7" means the first field is 10 characters wide, the second field is 18 characters wide, and the third field is 7 characters wide.