Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 5875 Views
- I also Faced
- E-Mail Answers
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 |
What is RESTART? How is it invoked?
what is a MODELDSCB?
How to override loadlib?
Which statement is used to identify the private libraries in job?
wht is sysudump n sysout,sysprint ?
What are the default system and catalog libraries in JCL?
What is the function of the dd avgrec keyword in sms datasets?
Can we give two user name in NOTIFY parameter in JOBCARD
What is concatenating?
what is d/f b/w sysout & sysprint
I have a job called careerride and some steps in it as step1,step2. But I want to execute step2 before step1 ? How do I do that?
can any one plzzzzzz tell the jcl code for creating ps using idcams
COBOL 
