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
how you can direct the data to spool using SYSOUT option?
What is the function of the steplib dd statement?
How does jcl act on code(if you take a cobol program)?
by using cond parameter maximum 8 cond can be coded in single cond means ?explain
What is catelog procedure and how many catelog procedure to use in one job?
What is job control language?
in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
What is one line to pass PARM from JCL to COBOL?
Define concatenating?
what is the purpose of coding class parameter in job statement?
What are steplib and joblib? What for they are used?
Explain the function of //cntl statement?
What is the function of a dd statement?
What is the maximum length of a single line of jcl?