• Created by user-cd56b, last updated on Aug 19, 2022 1 minute read

3.4.6 Alt. Seq.

Optional.

Specifies the name of an Alternate Collating Table to be used when sequencing the records for retrieval on a Keyed table.

Warning

  • At Table Creation time, you must have operational rights to the Alternate Collating Table. Alternate Collating sequences are not valid for key columns with a data type of decimal as it causes zoned key columns to default to unsigned sequence.

Platform Considerations

  • IBM i: This table attribute applies to IBM i databases only.
  • IBM i: The Alternate Collating Table name, if specified, is not validated to determine if it actually exists.
  • IBM i: When attempting to use any table that has been created with an Alternate Collating Table, the library list is used to locate the Table.
  • No labels