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
- 13753 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / vinodh
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 |
Post New Answer View All Answers
Name the parameters which can be used to limit the number of records written to a sysout dataset?
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
Brief description of inline procedure of jcl.
define cond parameter in jcl?
Explain the function of the dd dcb keyword?
What is catelog procedure and how many catelog procedure to use in one job?
which utility is used a dummy utility?
what are JCLLIB and STEPLIB in JCL?
What are hierarchy levels in jcl?
What methodology can be adapted to transfer data to a program that is coded using the exec statement?
How can values be passed from the job stream to an executable program?
Is it possible to define dd statements as you want?
Can I send output of job to my remote device careerride123?
Define concatenating?
What is concatenating?
