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 is RESTART? How is it invoked?

8 Answers   HSBC,


What does a disposition of (new,catlg,keep) for a dsn mean?

0 Answers  


What is the improvement to COND= in the latest version of MVS?

3 Answers  


What is the max blocksize for a Tape file?

2 Answers  


I have an job having three job steps.Suppose i want to call a pgm in step2 and aproc in step3.How to write the code?

2 Answers   IBM,






wt will happen to the step of a job if u code COND=ONLY

5 Answers   ADP,


I have two input SORTIN files and We need to create one SORTOUT file which contains data of both input files. What is the SortCard for this?. Suppose the length of the both files are different, then How we do it? Please reply ASAP

4 Answers   CSC,


Where can program checkpoints be stored for use in a restart?

0 Answers  


how to have variable length record in outrec..i have the requmt as follows.. i/p file variable lenght record output file : i need to alter the input and write into outrec(another file) sort fields: copy from(dd1) using ctl1 ctl1cntl dd * outfil fnames=xxx, outrec=(1,131) here i outrec is bombing with error..how to overcome this defect...???

1 Answers  


Give the syntax of job specifying jcl statement.

0 Answers  


What do you do if you do not want to keep all the space allocated to a dataset?

2 Answers  


Name the system library from which modules are retrieved at execution

3 Answers  


Categories