Interested to Buy Any Domain ? << Click Here >> for more details...
What is SORT ? How do we eliminate duplicate records ? How
do I select some records using SORT ?
- 9 Answers
- 36608 Views
- GE, Xansa, I also Faced
- E-Mail Answers
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
Explain the job statement in jcl?
In sms datasets, what is the function of the dd avgrec keyword?
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?
what is the use of IEBGENER utility?
Is acct parameter mandatory?
Name a few IBM utility programs, and explain its function.
How to override a dsn that is contained in a proc called by another proc? I need to do the override in the calling jcl?
how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?
Explain how can a jobs execution priority be modified?
How does jcl act on code(if you take a cobol program)?
How can a fb file convert to vb file using sort program?
what is JCL?
How can return codes be tested before execution of a job step?
When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File's Organisation ?
have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file
