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


Please Help Members By Posting Answers For Below Questions

what is the purpose of coding notify parameter in job statement?

683


in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?

820


If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?

784


Which dd parameters are required?

694


Is condition checking possible in jcl?

722






What methodology can be adapted to transfer data to a program that is coded using the exec statement?

608


What are steplib and joblib?

725


Explain the job statement in jcl?

653


Can an individual step be restricted from using all the jobs allowed cpu time?

1009


Explain the function of dd disp parameter?

595


how can the same proc be re-used and called by many jobs?

909


I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.

1953


Explain the jcl exec statement?

649


A chkpt is the parameter coded for multi-volume qsam datasets in a dd statement. When a chkpt is coded as chkpt=eov, a checkpoint is written to the dataset specified in the sysckeov statement at the end of each volume of the input/output multi-volume dataset. State whether true or false?

734


Name what parameter directs the output of the job log dataset?

563