wht r different types of sort fields in jcl ?



wht r different types of sort fields in jcl ?..

Answer / pullareddy

1. SORT FIELDS=COPY ===> To copy all the records from
SORTIN to SORTOUT.
2. SORT FIELDS=COPY,SKIPREC=100,STOPAFT=5 ===> TO copy the
records from 100 to 105.
3. SORT FIELDS=(STARTPOS,LENGTH,TYPE,ASC/DESC) ===> TYPE
can be: ZD(zoned decimal), CH(Charecter),BI(Binary),PD
(Packed decimal), and FS(Signed numbers).
4. INCLUDE COND=(STATPOS,LENGTH,TYPE,RO,VALUE) EX: INCLUDE
COND=(1,5,CH,EQ,C'PULLA) ===> To select the paticlular
record. same as above to omit the record replace INCLUDE
with OMIT.
5. INREC FIELDS=(15,5,6,6) ===> to restructure the input
file before feeding to sort.
6. OUTREC FIELDS=(1:1,20,21:C'PULLA',26:10Z,36:21,10) ===>
First 20 chars from input file followed by character PULLA
followed by 10 zeros followed by characters from 21 to 10
characters of input. the same can be codded as bellow.
OUTREC FIELDS=(1,20,C'PULLA',10Z,21,10).
7. SORT FIELDS=(1,5),EQUALS
SUM FIELDS=NONE ===> TO remove the duplicates in the key
field(1,5).

Is This Answer Correct ?    47 Yes 4 No

Post New Answer

More JCL Interview Questions

Explain the purpose of dd dummy statement?

0 Answers  


Can we use DISP=SHR in output file in JCL

0 Answers  


Why we will create load module in PDS only, Why nt in PS?

2 Answers   TCS,


AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE FILES IN JCL? CAN I GET THE PROGRAM FOR THIS

3 Answers  


i have a jcl calling proc which has 10 steps, i want to execute from step5 to step10, where can i code RESTART and COND parameter?

6 Answers   IBM,






Explain about LMGET�read a logical record from a data set

1 Answers  


I have DATE filed like DD-MM-YYYY, So I want output should be MM/DD/YYYY using JCL? Can anybody post the answer for above requirement?

4 Answers   BirlaSoft, FIS, Wipro,


how to convert fb to vb in jcl ?

5 Answers   IBM, Infosys,


What does a disposition of (NEW,CATLG,DELETE) mean?

3 Answers  


Mainframes gets a text file that contains the name of the file. Now using JCL i want to locate that file name in the mainframe system and perform further processing. Please tell how to proceed

0 Answers  


How does jcl act on code(if you take a cobol program)?

0 Answers  


What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?

0 Answers   IBM,


Categories