Write a JCL by using the below requirement:
File1 =1, File2 =11 and output needs to come as File3 =111?
Answer Posted / mdv
Step 1.
Add SEQNUM for both the files @ positions 3 to 8 and 2 to 7
respectively.
Step 2.
Join based on key and reformat as needed.
// SYSIN DD *
JOINKEYS FILE=F1,FIELDS=(3,6,A)
JOINKEYS FILE=F2,FIELDS=(2,6,A)
REFORMAT FIELDS=(F1:1,2,F2:1,1)
SORT FIELDS=COPY
/*
Note: Not tested.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
How does the jcl specify the job to os?
What is the purpose of dd * statement in jcl?
In sms datasets, what is the function of the dd avgrec keyword?
Explain the function of the dd dcb keyword?
Where & How Do You Code Identifier In Jcl?
What is timing concept in mainframe?
What is the function of job statement in jcl?
What are the rules employed while naming the steps in a job?
what is the compile process of cobol program expalin with code
i want to store 20 digits . how will u do it in cobol ?
Is it possible to code instream data in a PROC?
Explain how can the disposition of sysout datasets be set for an entire jobstream?
Can I send output of job to my remote device careerride123?