3.6.5 Alternate Collating Table (ALTSEQ)
Specify the name of an Alternate Collating Table to be used when sequencing the records for retrieval on a Keyed file.
Default = blank (none).
Rules
- Table name must conform to object naming standards for the operating system.
Warnings
- At File Creation time, you must have operational rights to the Alternate Collating Table. Alternate Collating sequences are not valid for key fields with a data type of packed decimal. Causes zoned key fields to default to unsigned sequence.
Tips & Techniques
- The Alternate Collating Table name if specified is not validated that it actually exists.
Platform Considerations
- IBM i: This file attribute applies to IBM i databases only.
- IBM i: When attempting to use any file that has been created with an Alternate Collating Table, the library list is used to locate the Table file.