BMC AMI Load DISCARDS

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

Related topics

Basic-options

BMC-AMI-Load-Syntax-diagrams

DISCARDS_SPE1907.png

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

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*