December 2002
Intermediate to advanced
928 pages
85h 29m
English
INFILE | INDDNfilename|* [os_specific_options] [BADFILE | BADDNbad_filename] [DISCARDFILE | DISCARDDNdiscard_filename] [DISCARDS | DISCARDMAXdiscardmax] [FIELDS TERMINATED BYcharacter]
Specifies the file containing the data to be loaded.
The BADDN, INDDN, and DISCARDDN keywords are provided for compatibility with DB2 syntax. Each INFILE can have its own bad file and discard file, as well as its own limit on the number of discards. If you omit the BADFILE or DISCARDFILE parameter and the job requires one, SQL*Loader will create a file with the name of the INFILE and either the .bad or .dis extension.