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
- 36900 Views
- GE, Xansa, I also Faced
- E-Mail Answers
Answer Posted / anoopkumarg
SORT is a utility(The program name maybe SYNCSORT or DFSORT)
that IBM provides which can do so many useful operations on
a flat file..like sorting the file based on a particular
condition, eliminate duplicates, extract some selective
fields into another file in the required order and the list
goes on..
To eliminate duplicates, we can use as below..
.
.
//SYSIN DD *
SORT FIELDS=COPY
SUM FIELDS=NONE
END
You can use "include condition" along with "sort fields" to
select desired records..the code goes like this..
.
.
//SYSIN DD *
SORT FIELDS=(<give sort condition here>)
INCLUDE COND=(<give the required condition here>)
END
In these cases, the SORT utility accepts one or more input
files and produces an output file which will contain the
desired records..
The IBM standard syntax of the sort command is given below..
SORT FIELDS=({begcol},{length},{fieldtype},{D|A}[,{begcol},
{length},{fieldtype},{D|A}]...)
INCLUDE COND=({begcol1},{length1},{fldtype1},{comp.oper},
{begcol2},{length2},{fldtype2})
Hope you got something from this explanation..
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What are steplib and joblib?
Immediate Job opening for mainframe professionals in Keane Bangalore. Please find the below details: Organization: Keane India Location: Bangalore Skill: COBOL, JCL,VSAM,DB2,CICS,IMS,REXX,CLIST Exp: 1 to 4 years only Employment Type: Permenant Employee Note: If you have attended keane interview in past 6 months please ignore this job opening. Please respond to email id keanemfjob@gmail.com OR keanemfjob@yahoo.in with your latest resume and following details, We will contact you within 24 hours: Total IT Exp: Exp in Mainframe: Current CTC: Expected CTC: Notice Period:
what are JCLLIB and STEPLIB in JCL?
How to alter the parameters for the existing gdg?
Can an individual step be restricted from using all the jobs allowed cpu time?
Name the statement which can be used to send data to another mvs jes3 node?
what is the JCL statement consists of?
What is the purpose of dd?
What is the function of //cntl statement?
What is the use of disp parameter?
how to run batch program without jcl?
Explain the function of job statement in jcl?
what is use of dsn parameter in dd statement?
How to pass the parameter in parm using linkage section ? (syntax)?
Explain the purpose of the dd keylen parameter?
