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
- 13690 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
what is DD statement is used in JCL?
a dd statement has 2 types of parameters. Name them?
What is the purpose of dd dummy statement?
Explain dfsort utility?
how you will the direct the data to spool using sysout option?
by using cond parameter maximum 8 cond can be coded in single cond means ?explain
Explain how can values be passed from the job stream to an executable program?
How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
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
what are the various stages of job processing?
How can a fb file convert to vb file using sort program?
what is the compile process of cobol program expalin with code
which utility is used to run a cobol-db2 program?
What are s0c1, s0c4, s0c5, s0c7 and socb?
