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


Please Help Members By Posting Answers For Below Questions

What dd statement is used to supply the name of a dataset?

1102


What is the use of disp parameter?

866


In job processing, what happens in conversion stage?

972


What is jcl in mainframe?

964


What are the difference between jcl and jes?

1319


how to do automated restart when a job abends?

1125


what is the resolution for sb37 error

8408


What is the function of a dd statement?

944


What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?

1078


Describe the various parameters utilized in the creation of a gdg?

903


how can the same proc be re-used and called by many jobs?

1205


How to do automated restart when a job abend?

1047


What is the function of the dd avgrec keyword in sms datasets?

1072


Differentiate between addressing mode and run mode.

807


What do you know about jcl?

872