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
- 13891 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 |
How can return codes be tested before execution of a job step?
Hi, My dataset have multiple records, say 100. I want to start copy records only after a record contain a specific value that may be in a specific position. Secondly I want to stop copying rest records if certain record contains a specific value. Can it be done using SORT/ICETOOL utilities?
In Job, there are 10 steps. If I want to execute the first 6 steps and don't want to execute from 7th to 10th step. What is the solution for this ?
How many positional parameters are there in job statement?
How can the disposition of sysout datasets be set for an entire jobstream?
How much space OS allocates when you create a PS or PDS?
What u mean by include statement in JCL ?
what is the use of JCL?
How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length ----TRY
How to execute only th 15th step of JCL consisting of 50 steps?
which utility is used a dummy utility?
. What is the difference between the following statements : I) step#1 exec PGM=accpay ii) step#1 exec tbalance
COBOL 
