We can use SORT to exclude the duplicate SORT FIELDS=NONE remove the dup f

How to exclude the duplicate records from two concateded
flat files (records from both files must be removed)?

Question Posted / mayank

1 Answers
5817 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

Please Help Members By Posting Answers For Below Questions

what is a jcl?

1119

Suppose I have a program in cobol name ”careerride” and want to execute the program by jcl. Specify the process?

1097

what is DD statement is used in JCL?

1176

What is the syntax of JCL statement?

1212

How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?

8542

which utility is used to sort a file in jcl?

1203

What statement can be used to send data to another mvs jes3 node?

1619

Is it possible to define dd statements as you want?

1097

Explain the purpose of dd * statement in jcl?

1046

I HAVE A VB BLOCK WHICH IS USED AS INPUT IN COBOL CONATINING SOME RECORDS CAN I CHANGE THE FILE FROM VB TO FB?

2541

Explain the function of dd name parameter with a 2 part structure; audit.report?

1444

what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?

1277

How to run cobol program using jcl?

1214

Can an individual step be restricted from using all the jobs allowed cpu time?

1537

I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?

1819