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 are JCLLIB and STEPLIB in JCL?
What does a disposition of (MOD,DELETE,DELETE) mean ?
Does jcl support automatic restart?
which utility is used to run a cobol-db2 program?
Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE
What is the significance of addrspc parameter in the exec statement?
What is the function of job statement in jcl?
Differentiate between addressing mode and run mode.
what are the types of abends that occur on job failure? And explain the possible causes of these
How to alter the parameters for the existing gdg?
Explain how can return codes be tested before execution of a job step?
What are the 4 fields in dd statement?
Name the statement which can be used to send data to another mvs jes3 node?
how can the same proc be re-used and called by many jobs?
What is the difference between run mode and addressing mode?