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.

Related topics

Basic-options

BMC-AMI-Load-Syntax-diagrams

EBCDIC

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.


 

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