duplicate | F1 for Mainframe

Tags

Usually you have a requirement of removing the duplicate records from a file using SORT with the option SUM FIELDS=NONE

If the requirement is to always have the first record of the input file (out of all duplicates) in the output file, then the EQUALS option will help you in doing it.

EQUALS option preserves the order of the records being read from the input files.

So your SORT card will look like.

SORT FIELDS=(1,80,CH,A),EQUALS
SUM FIELDS=NONE

——————————————————————————————————–

In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog

——————————————————————————————————–

You may also like to look at:

Important SQL CODES and ABEND CODES

SORT JOIN – TO JOIN TWO FILES BASED ON A KEY

KNOW YOUR MAINFRAME

REXX – INITIAL SETUP

SAS – SAMPLE PROGRAM

SORT – CONVERT PD to ZD IN DISPLAYABLE FORMAT (ZDF)

SORT – Alphanumeric Tests for INCLUDE and OMIT

SORT – EQUALS Option

SORT – PARSE – REFORMAT VARIABLE FIELDS

SORT – FINDREP, IFTHEN and INREC

SORT – JUSTIFY, SQUEEZE and OVERLAY

SORT – LOOKUP AND CHANGE

SORT – CONVERT PD to ZD and BI to ZD

SORT – OUTREC – TRAN

SORT – OUTREC – INSERT ZEROES, BLANKS, STRINGS

SORT – OUTPUT DATASET DCB (LRECL,RECFM,BLKSIZE)

SORT – INCLUDE and OMIT

SORT – Process Order of CONTROL Statements

SORT – How to use VB dataset (VLSHRT)

SORT – EDIT MASK PATTERNS

SORT – EDIT NUMERIC FIELDS (I,T,S)

SORT – EDIT FIRST AND LAST RECORD

SORT – SYMBOLS

SORT – TO REPLACE A CHAR WITH ANOTHER CHAR – ALTSEQ

SORT – SET RETURN CODE ‘04’ IF OUTPUT FILE IS EMPTY

SORT – INREC, INCLUDE and OMIT

SORT – SKIPREC and STOPAFT

SORT – INREC

SORT – SUM FIELDS

SORT – REMOVE DUPLICATES AND WRITE THEM TO XSUM

DFSORT – Informational and Error Messages

SORT JOIN – UNPAIRED RECORDS INDICATOR

SORT JOIN – TO JOIN TWO FILES BASED ON A KEY

SORT JOB – SIMPLE COPY

SORT TIPS

Rate this: