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 |
how to identify the file used in the JCL is an VSAM file. Just seeing the JCL code how can we track the file as VSAM file?
What is TimeStamp, What is TimeStamp error and What is the Abend Code for TimeStamp Error ?
When output dataset space is required, what quantity categories are used?
What are the rules employed while naming the steps in a job?
How to point my proc to production dataset always though i keep jcllib order=development.dataset? Is it possible?
Can we able insert data into a PS file Using IEBUPDTE utility??? If Yes can anyone describe it please..
what is a steplib
what is DD statement is used in JCL?
How can I override a dsn that is contained in a proc called by another proc? I need to do the override in the calling JCL.
Why 16 is used in calculating the DPRTY ? as, DPRTY = (num1, num2), THEN, DPRTY = 16* num1 + num2
What is the difference between Sysin,Sysout,Sysdbout and Sysudump?
I have a JCL with 10 steps, want to execute first 5 steps only, what are ways of doing it?is it possible to control through JOB card?