I've one sequential file, That file contains millians of
Junk & CHAR recoreds example

File 1
,,,,,...,,,.....,.,.INFOSYS.....,,,,,,,,,,,WIPRO...........,
,...,..,.

My questions is : I want omit the 44th posstion to 4 CHAR
(WIPRO) remaining things I want output file (including Junk
CHAR also)...
How can we slove this problem & give me a syntax.
Please provide the result as soon as possible.

Answers were Sorted based on User's Feedback



I've one sequential file, That file contains millians of Junk & CHAR recoreds example ..

Answer / srinivas yadav

//SYSIN DD *
SORT FIELDS = COPY
EXCLUDE=(44,4,CH,EQ,C'WIPR')
/*
//

Is This Answer Correct ?    13 Yes 1 No

I've one sequential file, That file contains millians of Junk & CHAR recoreds example ..

Answer / vs kumar

HI LU,

YOU HAVE MISSED THE SORT FIELDS = COPY
I HAVE CORRECTED IT. PLEASE LET ME KNOW IF I AM WRONG

//EXAMP JOB A400,PROGRAMMER
//STEP1 EXEC PGM=SORT
//SORTIN DD DSN=INP1,DISP=old
//SORTOUT DD DSN=OUTPUT,DISP=(,PASS),UNIT=3390,
// SPACE=(CYL,(5,1)),DCB=(LRECL=??)
//SYSIN DD *
SORT FIELDS = COPY
OMIT COND=(44,4,CH,EQ,C'WIPO')

Is This Answer Correct ?    5 Yes 1 No

I've one sequential file, That file contains millians of Junk & CHAR recoreds example ..

Answer / lu

//EXAMP JOB A400,PROGRAMMER
//STEP1 EXEC PGM=SORT
//SORTIN DD DSN=INP1,DISP=old
//SORTOUT DD DSN=OUTPUT,DISP=(,PASS),UNIT=3390,
// SPACE=(CYL,(5,1)),DCB=(LRECL=??)
//SYSIN DD *
OMIT COND=(44,4,CH,EQ,C'WIPO')

Is This Answer Correct ?    3 Yes 1 No

I've one sequential file, That file contains millians of Junk & CHAR recoreds example ..

Answer / pkb

This can be done using SORT utility
//STEP1 exec PGM=SORT
//STEPLIB ........
.....................
//SORTIN dd DSN=INPUT.FILE
...
//SORTOUT DD DSN=OUTPUT.FILE
...
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,73,74,10)
//SYSOUT DD SYSOUT=*

THE FILE LENGTH IS CONSIDERED AS 83

Is This Answer Correct ?    0 Yes 0 No

I've one sequential file, That file contains millians of Junk & CHAR recoreds example ..

Answer / naga

i think , WIPRO is 5 chars not 4 chars.

pls check the blow syntax.

SORT FIELDS = COPY
OMIT COND=(44,5,CH,EQ,C'WIPRO')

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More JCL Interview Questions

what is a cataloged procedure ?

1 Answers   Xansa,


I have a JCL with 10 steps, want to execute first 5 steps only, what are ways of doing it?is it possible to control through JOB card?

5 Answers   iGate,


What are the parameters that are used in creating a gdg?

1 Answers  


What are the common keyword parameters in both job and exec statements

4 Answers   Cap Gemini,


What is the meaning of keyword in JCL? What is its opposite?

1 Answers  


Can a job have only steplib and no joblib ?

6 Answers  


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?

2 Answers  


Is their any set of rules for dd? Explain.

1 Answers  


How can I write the joblog in the spool on normal end of a job step and direct the joblog to a dataset only if the step abends?

2 Answers  


How to create delta file using JCL

1 Answers   CTC,


What is the function of //jcllib statement?

1 Answers  


with out sorting how to copy records from one file to another file using jcl.Mean I have one input file in which the record are like 1,6,5,4,2,3(for example) and i want to copy to output file from top to bottom(without sorting) like 3,2,4,5,6,1.so I want the JCL for this.cna any one can answers?

1 Answers   TCS,


Categories