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
- 13696 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
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 |
hi friends........if u know syntax of IEBEDIT IN JCL
Is it possible to define dd statements as you want?
What is meant by S0C7 system abend code?
How does -818 sql error occur? Why does it happen and what can be done to overcome this error code?
do we need to mention the location of catalogued procedure for each it's call in a single job?
A statement about PROCs is " In PROCs, Symbolic Parameters can be assigned on PROC and EXEC", BUT On which EXEC, (i) On the JCL's EXEC which is calling to PROC1. (Inside JCL, EXEC PROC1) (ii) or On the PROC's EXEC where it calls the PGM1. (Inside PROC, EXEC PGM=PGM1)
I have a JCL with 100 steps. I want run the Alternate steps in the JCL ( Like 2 ,4,6,8 etc.. ). How can I acheive this scenario? If It is by Cond Parameter can you provide the Condition code for that?
5 Answers Polaris, Tech Mahindra, UST, Wipro,
Name the system library from which modules are retrieved at execution
How to pass data to a program that is coded in an exec statement?
When we give TYPERUN = SCAN , what are the syntax errors we get?
How do you access a file that had a disposition of KEEP?
Explain about LMPUT-
COBOL 
