DDS for physical and logical files


ALTSEQ (Alternative Collating Sequence) keyword for physical and logical files

Use this file-level keyword to direct the OS/400 program to use an alternative collating sequence table when sequencing the records of a file member for retrieval, if you specified a key for this file.

The format of the keyword is:

ALTSEQ([library-name/]table-name)

The name of the alternative collating sequence table is a required parameter value. The library-name is optional. If you do not specify the library-name, the OS/400 program uses the library list (*LIBL) at file creation time.

The ALTSEQ keyword is not valid under the following conditions:

The ALTSEQ keyword cannot be specified with the REFACCPTH keyword.

You must have use authority to the alternative collating sequence table. The alternative collating sequence table is created using the Create Table (CRTTBL) command.

ALTSEQ causes zoned key fields to default to unsigned sequence. You can override the default by specifying the SIGNED keyword for individual key fields.

Example:

The following example shows how to specify the ALTSEQ keyword for a logical file.

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
00010A                                      ALTSEQ(TABLELIB/TABLE1)
00020A          R RECORD1                   PFILE (PF1)
00030A             :
00040A             :
00050A             :
00060A            NAME          20
00070A             :
00080A             :
00090A          K NAME
     A

Records with format RECORD1 are sequenced by key NAME according to the alternative collating sequence table (TABLE1 in library TABLELIB).


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]