Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13899 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
when does a dataset go uncataloged?
Explain how can a jobs execution priority be modified?
define cond parameter in jcl?
Explain the function of job statement in jcl?
What are the parameter we cannot use in procedure?
Explain the function of dd name parameter with a 2 part structure; audit.report?
For what purpose steplib and joblib are used ?
How would you understand error(execution phase)?
how you can direct the data to spool using SYSOUT option?
What is the function of job statement in jcl?
Are there any set of rules for the names of the steps used in a job?
what are the statements that are not valid to be included in an include statement?
How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?
What is the difference between run mode and addressing mode?
Is condition checking possible in jcl?
