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
- 13757 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 |
Explain COND used in JCL?
If I update one or more members in a pds in the step 1, how can I reach these new contents to be used in the step 2 of the same job? To start a new job via intrdr is not satisfactory, because I must solve this problem in one job.
how to convert a file form fixed Length to variable length?
hi in one of the interview one asked me how to submit a job from cobol?as well as how to submit a jcl from CICS? can u pls any one tell me..
What is a GDG? How is it referenced? How is it defined? What is a MODELDSCB?
i want to restart frm step 2, previously i coded cond parameter on step2 wht happens at tht time ?
What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?
we define the array like this 01 array 02 veg occurs 10 times 03 days occurs 6 times 04 cost pic 9(5). but why don't we write it as 01 array 02 veg occurs 10 times 03 days occurs 6 time 04 cost pic 9(5). is there any error will occur ,what is it? and why don't 01,02,03 not contain picture clause? if we put pic in those is there any error will occur what is it will occur?
How do you submit JCL via a Cobol program?
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)
describe the dd statement,its meaning,syntax and keywords?
how to code instream data in procedure?
COBOL 
