Skip to Content

Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Load for Db2 13.1.

DISCARDS (for BMC AMI Load)

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).

Warning

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

Basic-options

Syntax-diagrams-for-BMC-AMI-Load

 

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

BMC AMI Load for Db2 12.1