What is SORT ? How do we eliminate duplicate records ? How
do I select some records using SORT ?
Answers were Sorted based on User's Feedback
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 |
Answer / prashanth
---sort is a sorting of records either in asc/ des order,
---sort field(6,10,ch,ASC) or sort field(6,10,ch,ASC),equal
sum field none
---sort field(6,10,ch,Asc) 6 is the starting position
10 record length
ch for alpnum (X)
asc order of sorting
Is This Answer Correct ? | 14 Yes | 6 No |
Answer / 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 |
Answer / dhan
DFSORT is one of the IBM product. It is a program you use to sort,
merge, and copy the data from one file to another file.
https://youtu.be/IPDyz2xl7Tk
https://youtu.be/9311_rE9LE8
https://youtu.be/HFT9wXtoo74
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chudir vai
yes I appreciate Banchod. I also want to add another
information. Sort is also a khanki. You should always
it
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / guest
sort is used to sort the data in asending or diseding order.
by using sort we can copy data from one file to another
file. by using some fields=none
Is This Answer Correct ? | 4 Yes | 6 No |
Answer / banchod
sort is nothing bt a big bal. it is used to burn others
bara. it is also the substance to hide ones gud.
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / jagan
# 1 ---sort is a sorting of records either in asc/ des
order,
---sort field(6,10,A,CH) or sort field(6,10,A,CH),equal
sum field none
---sort field(6,10,A,CH) 6 is the starting position
10 record length
ch for alpnum (X)
A order of sorting
Is This Answer Correct ? | 1 Yes | 9 No |
how to write a jcl prog to copy alternate recs from ps1 to another ps2,suppose ps1 having 10 recs?
What does a disposition of (NEW,CATLG,KEEP) mean?
what is a cataloged procedure ?
What are the parameter we cannot use in procedure?
How do you access a file that had a disposition of KEEP?
How can values be passed from the job stream to an executable program?
how do u send return code from cobol to jcl ?
how to count the number of members in pds?
Is it possible to define dd statements as you want?
What does S0C4 error mean?
How is a type of file defined in the jcl that executes the cobol program?
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?