Interested to Buy Any Domain ? << Click Here >> for more details...
Hi, can any one tell about " How do u eliminate the
duplicates "
- 2 Answers
- 6584 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 the difference between primary and secondary allocations for a dataset?
Which is the most widely used batch performance monitor for DB2?
What is the difference between static call & Dynamic call ?
There is a procedure in A.B.PROCS(PROC1) (member name is PROC1) //PROCA... There is a call to a procedure PROCA from a JOB. //STEP01 EXEC PROCA ... Here "PROCA" in JOB refers to the actual PROC name or the member name of the PDS where this PROCA is stored.
What is the DD statement for a output file?
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
How to delete generations of gdg without deleting gdg base?
Explain the function of job statement in jcl?
Can we use COND=EVEN on a job card, when jobs are scheduled through scheduler?
In SPACE,what is directory,RLSE
What are the 2 types of parameters in dd statement?
What is jcl in mainframe?
COBOL 
