We have two PS files,want to compare those files and put
the duplicate records in one file.
Input file 1 contains(1,2,4,9,10)
Input file 2 contains (1,4,5,11,12,14,16).
Help me with jcl.
- 6 Answers
- 14840 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhusha
Use join keys
//STEP01 EXEC PGM=SORT
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTJNF1 DD DSN=INPUT.FILE.ONE,DISP=SHR
//SORTJNF2 DD DSN=INPUT.FILE.TWO,DISP=SHR
//SORTOUT DD DSN=OUTPUT.FILE,
// DISP=(NEW,CATLG,DELETE),
// SPACE=(CYL,(100,200),RLSE),
// DCB=(RECFM=FB,BLKSIZE=0,LRECL=80)
//SYSIN DD *
SORT FIELDS=COPY
JOINKEYS FILES=F1,FIELDS=(1,10,A)
JOINKEYS FILES=F2,FIELDS=(1,10,A)
REFORMAT FIELDS=(F1:1,71,F2:1,9)
/*
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is concatenating?
List in order the hierarchical levels of jcl?
IIN APITUDE THEY GAVE ONLY 10 QUESTIONS.. THEY ARE SIMPLE ONE FROM NUMBER SERIES,BOATS,TIME & DISTANCE,PROFIT &LOSS,FIND OUT THE NUMBER ? 9 25 4 36 81 64 49 AND surveillance SPELLINGS E.T.C
what is DSN parameter and DISP parameter is used for?
What is the function of dd disp parameter?
Are there any set of rules for the names of the steps used in a job?
Are there any set of rules for the names of the steps used in a job? What are they?
List the different components of jcl statement?
How to do automated restart when a job abend?
Name a few IBM utility programs, and explain its function.
what is use of disp parameter in dd statement?
Explain the function of the steplib dd statement?
Explain how can return codes be tested before execution of a job step?
What happens if both JOBLIB & STEPLIB is specified ?
What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
