DISCARDFILE clause names the file to which records are written that fail the condition in the
WHEN clause. The discard file is created when the first record to be discarded is encountered. If the same external table is accessed multiple times, then the discard file is rewritten each time. If there is no need to save the discarded records in a separate file, then use
If you specify
DISCARDFILE, then you must supply either a directory object name or file name, or both. See "[directory object name:] [filename]".
NODISCARDFILE is specified, then the default is to create a discard file if at least one record fails the
WHEN clause. The name of the file will be the table name followed by
_%p and it will have an extension of