what is the sortcard for comparing two files with a field key
and get the duplicates in onefile and noduplicates in another
file
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
Name what parameter directs the output of the job log dataset?
Name a few IBM utility programs, and explain its function.
What is notcat 2 - gs?
What is the purpose of dd?
Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?
write a jcl to execute a job by 7:00 am on jan 20,1986?
What are steplib and joblib?
what is the purpose of coding class parameter in job statement?
a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?
How can a jobs execution priority be modified?
What do we mean by 'Virtual storage' for a dataset and for a JOBSTEP ? What is the significance of the following statement for a programmer 'Virtual storage results in program addresses being independent of the addresses that actually exist in a computer' ?
In sms datasets, what is the function of the dd mgmtclas keyword?
Is it possible to define dd statements as you want?
Explain the function of dd disp parameter?
How can an in-stream dataset be terminated?