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
What do you understand by the term “keyword” with respect to jcl and what is the opposite of the term?
when does a dataset go uncataloged?
how to compare two datasets without using superce because output is limited to 133 bytes
which utility is used to run a cobol-db2 program?
Explain the function of the steplib dd statement?
what is DSN in JCL and what are the parameters to declare the DSN?
What is the function of //jcllib statement?
Explain the function of //jcllib 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 to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you
I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?
How can return codes be tested before execution of a job step?
What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?
What is the function of dd disp parameter?
What do you understand by the term job time – out and how can you overcome that?