What is SORT ? How do we eliminate duplicate records ? How
do I select some records using SORT ?
Answer Posted / sanjeeva reddy
Sort: Sort utility is used to sort the data in particular order(Ascending or Descending order).
Eliminate Duplicate Records:
----------------------------
//SYSIN DD *
SORT FIELDS=COPY
SUM FIELDS=NONE
/*
Select Some Records:
--------------------
You can use "INCLUDE CODITION" along with "SORT FIELDS" to
select desired records.The code goes like this......
//SYSIN DD *
SORT FIELDS=(<Give The Sort Condition Here>)
INCLUDE COND=(<Give The Required Condition Here>)
/*
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What dd statement is used to supply the name of a dataset?
What is the use of disp parameter?
In job processing, what happens in conversion stage?
What is jcl in mainframe?
What are the difference between jcl and jes?
how to do automated restart when a job abends?
what is the resolution for sb37 error
What is the function of a dd statement?
What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?
Describe the various parameters utilized in the creation of a gdg?
how can the same proc be re-used and called by many jobs?
How to do automated restart when a job abend?
What is the function of the dd avgrec keyword in sms datasets?
Differentiate between addressing mode and run mode.
What do you know about jcl?