Interested to Buy Any Domain ? << Click Here >> for more details...
How to exclude the duplicate records from two concateded
flat files (records from both files must be removed)?
- 1 Answers
- 5841 Views
- I also Faced
- E-Mail Answers
Answer Posted / mayank
We can use SORT to exclude the duplicate
SORT FIELDS=NONE remove the dup from fileC
//STEP1 PGM=SORT
//*** concatinated input files
//SORTIN DD DSN=FILEA,DISP=SHR
// DD DSN=FILEB,DISP=SHR
//** output file contains records except for duplicate
//SORTOUT DD DSN=FILEC,
// DISP=(NEW,CATLG,DELETE),
// VOL=SYSDA,
// SPACES=(CYL(1,1),RLSE),
// DCB=(LRECL=80,RECFMT=F,BLKSIZE=0)
//** give the sort parameter in below sysin
//SYSIN *
SORT FIELDS=(start postion of rec, length of
rec,attribute, A/D)
SUM FIELDS=NONE
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
how do you access an uncataloged dataset in a jcl?
Are there any set of rules for the names of the steps used in a job? What are they?
How can the disposition of sysout datasets be set for an entire jobstream?
Explain the jcl exec statement?
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.
How would you understand error(execution phase)?
how to compare two datasets without using superce because output is limited to 133 bytes
What is the use of disp parameter?
Define concatenating?
What is the purpose of dd?
What is the purpose of dd dummy statement?
How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?
How dummy is used in jcl?
What is the function of //cntl statement?
Explain dfsort utility?
