How to exclude the duplicate records from two concateded
flat files (records from both files must be removed)?
Answer / 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 |
how do you code a null statement?
How do you pass parameters to the program as the job is being executed ?
how to concatenate datasets
what is the use of JCL?
How many days does a job remain in spool
1)what is compilation jcl for cobol program but it is calling another program 2)what is compilation jcl for cobol program but it is calling another program(in this, main program is pure cobol but sub program is cobol+db2 program anyone please answer me for above questions. it's very urgent
What is the meaning of keyword in JCL? What is its opposite?
What are the maximum and minimum sizes of any CONTROL AREA (VSAM datasets) ?
I have 255 procedures in a job, each procedure contain 2 steps.can we execute this job?
Is stepname is a MUST and should be unique also for each JOBSTEP ? or system can supply the stepname for a step which is not given a name by the programmer ?
what r the types of job control statements?
What is a COND parameter in JCL?