what is the sortcard for comparing two files with a field key
and get the duplicates in onefile and noduplicates in another
file
- 3 Answers
- 12417 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / arthi
JOINKEYS F1=FILE1,FIELDS=(1,10,A)
JOINKEYS F2=FILE2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCHED,INCLUDE=(22,1,CH,EQ,C'B')
OUTFIL FNAMES=UNMATCHED,INCLUDE=(22,1,CH,EQ,C'N')
| Is This Answer Correct ? | 4 Yes | 0 No |
Refining the above sort card statement after executing it
SORT FIELDS=COPY
JOINKEYS FILES=F1,FIELDS=(1,10,A)
JOINKEYS FILES=F2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCH,INCLUDE=(22,1,CH,EQ,C' ')
OUTFIL FNAMES=UNMATCH,INCLUDE=(22,1,CH,EQ,C'N')
| Is This Answer Correct ? | 3 Yes | 0 No |
what is check pending option
What is order of searching of the libraries in a JCL?
what is a cataloged procedure ?
If there are five steps in a JCL i have to execute the 3rd step, bypass the 4th step and execute the 5th step how do i do this?
13 Answers Cognizant, Convergys, IBM, TCS, Wipro,
what's the significance of freespace(0 0) and freespace(100 100)
What are hierarchy levels in jcl?
Can we use empty VSAM as input?
Suppose we have 5 steps in a job.No step should be executed After submitting every step in a job
What does a disposition of (new,catlg,keep) for a dsn mean?
What do you know about jcl?
What is the difference between the JOBLIB and the STEPLIB statements?
What u mean by include statement in JCL ?
COBOL 
