Hi, can any one tell about " How do u eliminate the
duplicates "

Answers were Sorted based on User's Feedback



Hi, can any one tell about " How do u eliminate the duplicates "..

Answer / bhaskar reddy

//Sysin dd *
sort fields=(1,5,ch,A)
sum fields= none
/*
//

if u want all dupli.in one file u can use
//Sysin dd *
sort fields=(1,5,ch,A)
sum fields =none, xsum
/*
//
XSUM is the output file name. all duplicate records moved to
this file

Is This Answer Correct ?    8 Yes 1 No

Hi, can any one tell about " How do u eliminate the duplicates "..

Answer / rammateti

By using DFSORT we can eliminate the duplicates

//Sysin dd *
sort fields=(1,5,ch,A)
sum fields=
/*
//
in the above dfsort we use sum fields= empty then it
eliminate the duplicates

if u want all dupli.in one file u can use
sum fields = xsum........
by (prathap)

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More JCL Interview Questions

What are three parameters you can specify on Job statement as well as on exec stmt ?

1 Answers  


AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE FILES IN JCL? CAN I GET THE PROGRAM FOR THIS

3 Answers  


What is DSNDB06 ?

1 Answers  


How to copy one PS file to multiple PS files with same data?

1 Answers  


A job has 150 steps i want to execute only 57th step

3 Answers   Cognizant,






There are two input sorting files and there is a need to create one sort out file which contains data of both input files. What is the sort card for this. Write a sample JCL for this using a control card?

3 Answers  


//ERFDS JOB //STEP1 //STEP2 //STEP3...COND=(4,LT) //STEP4 1.CONDITION IN STEP3 REFERS TO WHICH STEP'S RETURN CODE (STEP1 OR STEP2)? 2.IN ABOVE PROGRAM IF CONDITION SATISFIES IN STEP3 WHICH STEPS WILL EXECUTE?? AND WHY? IF CONDITION IN STEP3 SATISFIES

5 Answers   IBM,


What is catelog procedure and how many catelog procedure to use in one job?

2 Answers   Infosys,


what does mvs stand for?

1 Answers   IBM,


what sort card you will use to copy the data from one dataset to another dataset?

0 Answers   IBM,


Is CPU time assigned to a JOB and JOBSTEP BOTH, by default ?

4 Answers   IBM,


What is the error/SOC code if dd names are not sysut1 and sysut2 in IEBGENER?

1 Answers   CTS,


Categories