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 |
In jcl i have 255 steps. In 255 step i declared proc. In proc i have 20 steps this job is executable or not? why?
What is the significance of addrspc parameter in exec statement?
How can return codes be tested before execution of a job step?
How to overide the symbol parameter in the jcl ?
what is the function of spool command?
What are SD37, SB37, SE37 abends?
How can an in-stream dataset be terminated?
how can handle the s0c4 abend???
what is the use of IEBGENER utility?
How to identify where file is empty or not? How many ways are there to identifying?
What parameter of the job statement is used to limit the cpu time consumed by the job?
How many types of libraries are there in JCL ?