I have two input files
i/p1
name id-key flag date
i/p 2
name id-key date
if id-key matches in the both the files then it should
write the output file from i/p1 with flag 'Y'. It should be
done thru JCL sort card ,Please provide the info on this.
---Note : output file should have all records from i/p1
with proper Flag.
Answers were Sorted based on User's Feedback
Answer / muttaiah
Please give us a sample of both the I/P files and the data
you expect in O/P files so that it will be useful for us to
answer
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vivek chandrasekaran
Give the two input files to be compared as
//SORTIN DD DSN=INPUT1,DISP=SHR
// DD DSN=INPUT2,DISP=SHR
//SORTOUT DD DSN=OUTPUT,DISP=...
//SORTXSUM DD DSN=MATCH,DISP=(NEW,CATLG,DELETE),..
//SYSIN DD *
SORT FIELDS=(11,5,CH,A),EQUALS
SUM FIELDS=NONE,XSUM
Considering name length 10 and key length 5 starting from
11 pos. XSUM will capture the duplicates. EQUALS will keep
the first duplicate record. To put 'Y' flag use OUTREC
FIELDS=(1:1,15,16:C'Y',17:17,8) considering date length 8
starting from 17 pos.
SUM FIELDS=NONE
Is This Answer Correct ? | 0 Yes | 0 No |
common jcl abends??
i have a base gdg consisting of 12 versions like jan to dec. i need to concatante this gdg to another gdg which have version 1 or to the base gdg itself can anyone give me the code pls ?
what is meant by jobtrac?
What is the function of the dd mgmtclas keyword in sms datasets?
Which COND paramter will u use to execute the step only if the previous step does not execute
Ques: How can we code COND parameter in a JCL so that only even steps (or only odd steps) get execute??
What is the function of the dd avgrec keyword in sms datasets?
wht is sysudump n sysout,sysprint ?
How to execute step2,step5,step7 of a proc of 10 steps? You are not allowed to change in JCL.
What is the purpose of dd?
List the various advantages of using jcl language?
What is the difference between BLKSIZE and LRECL?