General Command Line
$ syncsort SyncsortOptions
$ syncsort /INSERT syncsort.script
For example:
$ syncsort /INSERT syncsort.script /STATISTICS /END
syncsort.script is collect of syncsort options:
/INFILE DATA.IN SEQUENTIAL MFLINESEQUENTIAL 20 /PADBYTE X"20" /FIELDS FLD_CH_1_END 3 CH 2 /KEYS FLD_CH_1_END ASCENDING /STABLE /OUTFILE DATA.OUT SEQUENTIAL MFLINESEQUENTIAL 20 OVERWRITE
Notice:
1. Options in script are case-insensitive
2. comment in script is /* comment content */
Common Option
/COPY
To specify that SyncSort is to perform a copy (rather than a sort, join, or merge).
The /COPY option will not change the order of the records.The number
of output records will be the same as the number of input records
For Example:
DATA.IN1:
11CCcc11 22AAaa22 33BBbb33 44XXxx44
DATA.IN2:
11CCccCC 22AAaaAA 33BBbbBB 44XXxxAA
SORT.SCRIPT:
/INFILE DATA.IN1 SEQUENTIAL MFLINESEQUENTIAL 20
/INFILE DATA.IN2 SEQUENTIAL MFLINESEQUENTIAL 20
/COPY
/OUTFILE DATA.OUT SEQUENTIAL MFLINESEQUENTIAL 20 OVERWRITE
DATA.OUT:
11CCcc11 22AAaa22 33BBbb33 44XXxx44 11CCccCC 22AAaaAA 33BBbbBB 44XXxxAA
/MERGE
To specify that SyncSort is to perform a merge (rather than a sort, join, or copy).
Compared with /COPY option, the /MERGE option will merge input records in sorted data.
For Example:
SORT.SCRIPT:
/INFILE DATA.IN1 SEQUENTIAL MFLINESEQUENTIAL 20
/INFILE DATA.IN2 SEQUENTIAL MFLINESEQUENTIAL 20
/MERGE
/OUTFILE DATA.OUT SEQUENTIAL MFLINESEQUENTIAL 20 OVERWRITE
DATA.OUT
11CCcc11 11CCccCC 22AAaa22 22AAaaAA 33BBbb33 33BBbbBB 44XXxx44 44XXxxAA
(Since there is no merge field is specified; the default merge field is used. But I really don't know how merge fields are used; as I tested, fields can work fine with sort option, but not with merge option.)
/INFILE
To define a file as a source of input records.
Format:
/INFILE file_attribute record_limit
For Example:
/infile sort1.in fixed 80
/infile sort.in ":"
/OUTFILE
To specify a file as a destination of output records.
Format:
/OUTFILE file_identifier [file_qual …]
For Example:
/outfile sort1.out fixed 80
/INCLUDE
To select records for processing or for an output destination.
Format:
/include condition
/OMIT
To omit records from further processing or from an output destination.
Format:
/omit condition
/FIELDS
To describe the layout(s) of the input records in terms of named positional or
delimited fields.
Format:
/fields name start type length, ...
For Example:
/fields cust_id 3 integer 4, cust_name 7 character 40
/fields po_number 1 char 10, item_code 15 char 5, num_ordered 23 int 2
/KEY
To specify the key fields used for ordering the input records.
Format:
/key fieldname [ASCENDING|DESCENDING]
For Example:
/key volume_id
/keys state ascending, county ascending, amount descending
/keys cust_id, trans_date desc, trans_amount
/PADBYTE
To specify the value of the character for padding short records and keys.
Format:
/PADBYTE "a"|X"xx"|O"ooo"
For Example:
/padbyte " "
/padbyte x"20"
/INSERT
To augment an application definition with text contained in a file.
/STABLE
To indicate that the order of equal-keyed records is to be maintained.
/STATISTICS
To request statistics concerning SyncSort's execution.