Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
Ajay Baghel wrote:
EQUALS is an option and not a parameter for SORT statement.
Have you looked at the Syncsort manual?
Chapter 2. SyncSort Control Statements wrote:
EQUALS/NOEQUALS Parameter (Optional)
The EQUALS parameter insures that the original order of equal-keyed records is preserved. These records will be in the same order in the output file as they were in the input file. NOEQUALS, the default, specifies that equal-keyed records may not be written in their original input order.
When the EQUALS parameter is used with the SUM control statement, the first of the equal-keyed records is retained with the sum; all other records are deleted after the specified field(s) have been summed.