Previous Topic: 7.5.4 Account Codes

Next Topic: 7.5.6 @@FIRST and @@LAST

7.5.5 File Sort Sequences


In order to simplify the specification of the file sort
sequences, MSI breaks the sort sequence into two pieces:the
User and the Timespan Sequences.  The User Sequence is
defined by the SEQUENCE, and APPENDSEQUENCE statements.

The Timespan Sequence determines how a file is sorted with
regard to the timespan where it is active (detail,days,
...).  It is automatically generated by MSI and cannot be
directly modified.  The ADD statement allows for limited
changes in the Timespan Sequence for specific timespans.
AFTERSEQUENCE allows data elements to be added at the end of
the Timespan Sequence.

To insert elements before the Timespan sequence, you have to
add after the User Sequence using the APPENDSEQUENCE.