What is SORT ? How do we eliminate duplicate records ? How
do I select some records using SORT ?
Answer Posted / anoopkumarg
SORT is a utility(The program name maybe SYNCSORT or DFSORT)
that IBM provides which can do so many useful operations on
a flat file..like sorting the file based on a particular
condition, eliminate duplicates, extract some selective
fields into another file in the required order and the list
goes on..
To eliminate duplicates, we can use as below..
.
.
//SYSIN DD *
SORT FIELDS=COPY
SUM FIELDS=NONE
END
You can use "include condition" along with "sort fields" to
select desired records..the code goes like this..
.
.
//SYSIN DD *
SORT FIELDS=(<give sort condition here>)
INCLUDE COND=(<give the required condition here>)
END
In these cases, the SORT utility accepts one or more input
files and produces an output file which will contain the
desired records..
The IBM standard syntax of the sort command is given below..
SORT FIELDS=({begcol},{length},{fieldtype},{D|A}[,{begcol},
{length},{fieldtype},{D|A}]...)
INCLUDE COND=({begcol1},{length1},{fldtype1},{comp.oper},
{begcol2},{length2},{fldtype2})
Hope you got something from this explanation..
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Mention the types of job control statements?
What is the function of job statement in jcl?
Which statement is used to identify the private libraries in job?
How to do automated restart when a job abend?
Explain the purpose of dd * statement in jcl?
how JCL works?
Can I send output of job to my remote device careerride123?
What is the function of the dd dcb keyword?
How to pass the parameter in parm using linkage section ? (syntax)?
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
define cond parameter in jcl?
Must tape dataset definitions include vol=ser specifications?
Name the statement which can be used to send data to another mvs jes3 node?
How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?
which parameter is used to check the syntax of a jcl without executing it?