(Contents)(Previous)

DATALOAD with~Input Made in Default Format

A DATALOAD statement without column descriptions can be used when the input file was created from one table with the statement DATAEXTRACT * FROM. In this case, the input file contains the necessary column descriptions.

Example:

DATALOAD TABLE customer

INFILE customer.load

NULL '-@-'

LOAD generates the required column descriptions from the INFILE and then waits for data for all the columns of the table at those positions which follow from the SET parameters or file options.

Any file options for overriding the SET parameters are possible. NULL values are entered if the NULL string is found at a computed position.

This format of the DATALOAD statement can also be used together with the file option COMPRESS.


(Contents)(Previous)