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

Can we delete the data using IEFBR14 , IEBGENER??

5 Answers   Kanbay,


What is the function of job statement in jcl?

0 Answers  


can u explain gdg with example wht happens if we give limit,empty,noempty,scartch and no scartch

1 Answers   IBM,


what is mainframe?

4 Answers   CGI,


How to search strings in multiple dataset with conditions 'string1 & string2'?

1 Answers   IBM,






what EXEC statement is and what is the syntax of EXEC statement used in JCL?

0 Answers  


How to override a dsn that is contained in a proc called by another proc? I need to do the override in the calling jcl?

0 Answers  


what is use of space parameter in dd statement?

0 Answers   IBM,


what is A-MODE and R-MODE?

2 Answers  


Is automatic restart possible in jcl? If yes, how?

0 Answers  


what operation is performed by job statement?

0 Answers   IBM,


What all are the changes to be made in JCL so as to do testing?

2 Answers   TCS,


Categories