Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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)?



How to exclude the duplicate records from two concateded flat files (records from both files must ..

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

Post New Answer

More JCL Interview Questions

how do you code a null statement?

0 Answers   IBM,


How do you pass parameters to the program as the job is being executed ?

2 Answers  


how to concatenate datasets

5 Answers   EDS,


what is the use of JCL?

0 Answers  


How many days does a job remain in spool

7 Answers   Syntel,


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

1 Answers  


What is the meaning of keyword in JCL? What is its opposite?

1 Answers  


What are the maximum and minimum sizes of any CONTROL AREA (VSAM datasets) ?

2 Answers   Patni,


I have 255 procedures in a job, each procedure contain 2 steps.can we execute this job?

2 Answers  


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 ?

6 Answers   IBM,


what r the types of job control statements?

2 Answers  


What is a COND parameter in JCL?

10 Answers   TCS,


Categories