wht r different types of sort fields in jcl ?
Answer Posted / 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 View All Answers
What is the purpose of the dd keylen parameter?
Is it possible to code instream data in a PROC?
Can an individual step be restricted from using all the jobs allowed cpu time?
what is a jcl?
Which dd parameters are required?
Can we use DISP=SHR in output file in JCL
Differentiate between addressing mode and run mode.
I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?
Is it possible to define dd statements as you want?
What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?
Suppose there are 2 Input files Infile-1 and Infile-2. Both the Files contain Employee Records. You need to compare both the files and Write the Common Records in third file named Outfile. How can we do this using File-Aid?
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
Can we call instream to catalog and catalog to instream?
what is use of dcb parameter in dd statement?