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

I need exexution process for JCL programs

2278

---

how can you check if a file is empty using jcl?

1424

---

Name a few IBM utility programs, and explain its function.

4977

---

what is “Cond= even” and “Cond=only”?

1313

---

What is the function of a dd statement?

1209

---

What are the jcl procedures?

1122

---

what JCL Procedures?

1255

---

What is catelog procedure and how many catelog procedure to use in one job?

8694

---

how you can direct the data to spool using SYSOUT option?

1462

---

What dd statement is used to supply the name of a dataset?

1387

---

What do you understand by the terms: joblib and steplib?

1178

---

How do you create a temporary dataset?

1187

---

How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?

8585

---

Is automatic restart possible in jcl?

1223

---

What are steplib and joblib?

1170

---