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 are JCLLIB and STEPLIB in JCL?

654


What does a disposition of (MOD,DELETE,DELETE) mean ?

651


Does jcl support automatic restart?

734


which utility is used to run a cobol-db2 program?

789


Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE

1953






What is the significance of addrspc parameter in the exec statement?

607


What is the function of job statement in jcl?

624


Differentiate between addressing mode and run mode.

604


what are the types of abends that occur on job failure? And explain the possible causes of these

1104


How to alter the parameters for the existing gdg?

700


Explain how can return codes be tested before execution of a job step?

808


What are the 4 fields in dd statement?

726


Name the statement which can be used to send data to another mvs jes3 node?

589


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

892


What is the difference between run mode and addressing mode?

619