Default language.

Limited supportBMC 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.

ORDER YES

The ORDER YES option tells BMC AMI Load to sort the table rows in clustering index order.

ORDER YES.png

This option overrides a value of NO for the BMC AMI Load SORT parameter.

The following considerations apply to ORDER YES:

  • ORDER YES affects only new rows that you are loading. For a RESUME YES job, BMC AMI Load does not mix new rows with existing rows.
  • The encoding scheme of the table determines the collating sequence for character data. For example, if the table is defined as EBCDIC, the collating sequence will be EBCDIC.
  • If you specify the LOADPLUS option ORDER YES ASSOCIATE, BMC AMI Load terminates. BMC AMI Load ignores the LOADPLUS options ORDER NO and ORDER PRESORTED.

Related topics

Basic-options

Syntax-diagrams-for-BMC-AMI-Load

EBCDIC

 

 

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