Syncsort

INCLUDE OMIT Substring Comparison using SORT

INCLUDE OMIT Substring Comparison You can use the INCLUDE OMIT Substring Comparison statement in conjunction with other options to select/omit…

5 years ago

PARM: How to use in SORT JCL with examples

DYNALLOC PARM: This option requests the dynamic allocation of SORTWK data sets. DYNALLOC=OFF can be specified to override a DYNALLOC=ON…

6 years ago

PUSH unique ID and SEQ number using IFTHEN

PUSH defines the input field, sequence number, or identifier that will be overlaid for each group’s records. For fixed-length records,…

6 years ago

PARSE fields using IFTHEN parameter

PARSE and IFTHEN PARSE are new options that allow you to extract variable position/length fields into fixed-length parsed fields defined…

6 years ago

SEQNUM: How to use in SORT JCL with examples

SEQNUM creates & inserts sequence numbers in the output record. The sequence numbers are assigned in the order in which…

6 years ago

ICETOOL : Matching records from different data sets

ICETOOL is a batch front-end utility that uses the capabilities of DFSORT toperform the operations you request. Input and output…

6 years ago

Fill Method: Paired and unpaired records

Fill Method Paired and unpaired records - This example illustrates an alternative way to create three output files; paired F1/F2…

6 years ago

Indicator method: Paired and unpaired records

Indicator method: Paired and unpaired records - This example illustrates how you can create three output files; paired F1/F2 records,…

6 years ago

Unpaired records F2 using SORT Utility

Unpaired records F2: This example illustrates how you can select only unpaired records from one of two files. In this…

6 years ago

Paired records with duplicates using SORT

Paired records with duplicates: This example illustrates how you can join paired records from two files, both of which have…

6 years ago

Paired records without duplicates using SORT

Paired records without duplicates - ASA (formerly ANSI)control characters appear in Position 5 for variable-length records (just after the Record…

6 years ago

JOINKEYS joining two files using SORT

JOINKEYS feature joins transactions/records from two different files based on certain keys (i.e. fields with common information). The SORTJNF1 and…

6 years ago

STOPAFT SKIPREC condition in SORT JCL

In SORT JCL, the STOPAFT SKIPREC are two conditions that control the processing of input records. You can use the…

6 years ago

INCLUDE OMIT condition in SORT JCL

You can use the INCLUDE OMIT statement in conjunction with other options to select/omit the number of records to be…

6 years ago

IFTHEN Syncsort utility with examples

IFTHEN statements allow you to reformat different records in different ways by specifying how build or overlay items are to…

7 years ago