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 is RESTART? How is it invoked?
What does a disposition of (new,catlg,keep) for a dsn mean?
What is the improvement to COND= in the latest version of MVS?
What is the max blocksize for a Tape file?
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?
wt will happen to the step of a job if u code COND=ONLY
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
Where can program checkpoints be stored for use in a restart?
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...???
Give the syntax of job specifying jcl statement.
What do you do if you do not want to keep all the space allocated to a dataset?
Name the system library from which modules are retrieved at execution