Answer / 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..

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

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>)
/*

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

Answer / chudir vai

yes I appreciate Banchod. I also want to add another
information. Sort is also a khanki. You should always
it

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

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.

Answer / amruta

we can select by using BY variables

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

HOw to submit a job from other user id.? for exp some other job name like "t4622sdx".now i want to submit that job from my user id?(we don't know that location at all Just we know job name)

1 Answers   MSN Pharma, UST,

Explain about LMMFIND - find a library member

1 Answers  

What is S322 abend ?

5 Answers  

whats the difference between empty and noempty of GDG?

4 Answers   Patni,

Is their any limit for data sets?

0 Answers  

using cursor how can you fetch more than one record into a variable

3 Answers   Syntel,

Hi, I have 3 files say file A , file B and file C.I want to form an output file in which i will have all the records from file A. Files B and C also may contain records that are present in file A.I want those records also to be included in my output file. for eg: file A contains: 1 2 3 file B contains: 2 4 5 file C contains: 1 3 5 So in my output file should look like: 1 2 3 2 1 3 Can any one help ???.....thanks in advance.

2 Answers  

How would you understand error(execution phase)?

0 Answers  

What are the common jcl syntax errors you get? This is not abends?

1 Answers  

i have a file which contains duplicates ? my requirement is to eliminate duplicates and these elminated duplicates should be moved to another file can any code this using sort ?

3 Answers   IBM,

We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?

0 Answers   IBM,

Why block size is multiple of lrecl in jcl?

0 Answers