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
- 12454 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
a dd statement has 2 types of parameters. Name them?
Is automatic restart possible in jcl? If yes, how?
how would you create a temporary dataset? And where will you use them?
What is the function of a dd statement?
What do you understand by the term job time – out and how can you overcome that?
What is NOTCAT ?
how do you create a dataset in a jcl with the same file organisation as that of another existing dataset?
Where can program checkpoints be stored for use in a restart?
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
what is the purpose of coding notify parameter in job statement?
Is automatic restart possible in jcl?
how JCL works?
How to pass data to a program that is coded in an exec statement?
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?
How gdg are concatenated?
