The DISCARDS option specifies the discard limit, which is the number of error records allowed before a load terminates. 

Discard limit

You can specify 0 or any positive integer. For example, if you specify DISCARDS 1, the load terminates when it encounters the first errant record. If you specify DISCARDS 0, BMC AMI Load  will discard all errant records rather than terminate. The default value is zero (0).

Important

A load replace supplied with two duplicate records must discard them both, this load will terminate if DISCARDS 1.

IGNORE

(PTF BQU2361 applied) The IGNORE keyword tells BMC AMI Load  to not discard the records of the specified discard types. A discard violation that is ignored does not count towards the discard limit.

The discard type can be one of the following:

WHEN

Applies to records that are:

• Not selected by any INTO statement
• Discarded because of a mismatch in the table or column definition when specifying FORMAT UNLOAD

PART

Applies to records that are not selected by any of the partitions being loaded.

Sample syntax

Use the following syntax, DISCARDS integer IGNORE discardType,discardType,..., to define the discard limit and type. For example: 

DISCARDS 1 IGNORE WHEN,PART

Related topics