Hi, can any one tell about " How do u eliminate the
duplicates "
Answers were Sorted based on User's Feedback
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 |
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 |
What are three parameters you can specify on Job statement as well as on exec stmt ?
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
What is DSNDB06 ?
How to copy one PS file to multiple PS files with same data?
A job has 150 steps i want to execute only 57th step
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?
//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
What is catelog procedure and how many catelog procedure to use in one job?
what does mvs stand for?
what sort card you will use to copy the data from one dataset to another dataset?
Is CPU time assigned to a JOB and JOBSTEP BOTH, by default ?
What is the error/SOC code if dd names are not sysut1 and sysut2 in IEBGENER?