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
- 13596 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
In job processing, what happens in conversion stage?
what is a jcl?
When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?
What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?
whats the diff bw the evaluate also and and?
I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.
Suppose there are 2 Input files Infile-1 and Infile-2. Both the Files contain Employee Records. You need to compare both the files and Write the Common Records in third file named Outfile. How can we do this using File-Aid?
how do you access an uncataloged dataset in a jcl?
Explain how can values be passed from the job stream to an executable program?
Explain how can the submitting users racf authority be overridden in a job stream?
what is use of disp parameter in dd statement?
How gdg are concatenated?
Define concatenating?
What are the parameter we cannot use in procedure?
define cond parameter in jcl?
