I tried the code you supplied me, but it eliminated more than just the
duplicates. I have experimented for a while without success.Since the real
data has social security numbers in it, I privately e-mailed you with the
results of a limited test, hoping you would see what I did wrong. I'm
Howard Brazee wrote:
I tried the code you supplied me, but it eliminated more than just the
duplicates. I have experimented for a while without success.Since the
real
data has social security numbers in it, I privately e-mailed you with the
results of a limited test, hoping you would see
For closure: Howard sent me his input data offline. With this more
extensive set of input data, I was able to see more clearly what he was
trying to do. He had non-duplicate records in his input file, which I
hadn't realized from the smaller input sample. That meant he needed to use
LAST
On 25-Jul-2005, [EMAIL PROTECTED] (Frank Yaeger) wrote:
I guess I don't understand what you're trying to do. For the records you
showed,
you were treating records with 'N' in 22 as duplicates even though they had
different
characters in 21 ('*' and 'L'). If you are looking at 21-22, then
:[EMAIL PROTECTED] On
Behalf Of Howard Brazee
Sent: Tuesday, July 26, 2005 8:38 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Re: Duplicate sort order
On 25-Jul-2005, [EMAIL PROTECTED] (Frank Yaeger) wrote:
I guess I don't understand what you're trying to do. For the records
you showed, you were
The quickest wayI know of is to split the file into 2 files one
contain the 'L' and another that don't.
sort both removing duplicates ( are there multiple ''L' records?)
then merge the files removing duplicates and put the 'L' records first.
MIke
On 26-Jul-2005, [EMAIL PROTECTED] (Coatney, Bill) wrote:
Why not just change the sort statement from SORT
FIELDS=(1,10,CH,A,21,2,CH,A)
I need to eliminate duplicates - with column 21 not being part of the duplicate
check, but with column 21 sorted anyway - so that the last duplicate is
dumb way without using merge
1. sort using your control cards but add INCLUDE to get just the 'L'
2, second sort using same control cards with include anything not 'L'
3. concat 'L' data first other second
sort with your control cards and specify OPTIONS EQUALS which will
keep the 'L' s first
Howard Brazee wrote:
Am I being more clear now?
I'm not sure. It would have helped if you'd answered the question I asked:
Are you looking for L specifically, or L because it collates after '*'
or what?
If you want the 'L' because it collates after the '*', then this
DFSORT/ICETOOL job
would
On 26-Jul-2005, [EMAIL PROTECTED] (Frank Yaeger) wrote:
Are you looking for L specifically, or L because it collates after '*'
or what?
I suspect the latter.
At any rate, I'll try your multi-pass solution. I was thinking that would be
what was needed, but was hoping not. (I'll have to
Howard Brazee wrote:
Now I have to persuade people that it's time to allow some ICETOOL instead
of
DFSORT in. In the past I've been told everybody knows DFSORT and we
don't want
to train people in ICETOOL.It's a hard sell. The LASTDUP might do
it - or
it might not.
I suspect that
On 26-Jul-2005, [EMAIL PROTECTED] (Frank Yaeger) wrote:
In that case, the following DFSORT/ICETOOL job would do
what you want:
//S2EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//T1 DD DSN=T1,UNIT=SYSDA,SPACE=(CYL,(5,5)),DISP=(,PASS)
//OUT
Howard Brazee wrote:
No USING CTL1 in this sort.
Oops. Yes, it should have the USING(CTL1). Just a fingercheck.
Frank Yaeger - DFSORT Team (IBM)
Specialties: ICETOOL, IFTHEN, OVERLAY, Symbols, Migration
= DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/
I'm wanting to sort a file that contains the following data:
2123456789{ *E03
2123456789{ *E03
+1+2+---
2123456789{ *E03
2123456789{ *E03
2123456789{ *E03
2123456789{ *N03
2123456789{
Howard Brazee wrote:
I'm wanting to sort a file that contains the following data:
2123456789{ *E03
2123456789{ *E03
+1+2+---
2123456789{ *E03
2123456789{ *E03
2123456789{ *E03
2123456789{ *N03
On 25-Jul-2005, [EMAIL PROTECTED] (Frank Yaeger) wrote:
//S1EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//OUT DD DSN=... output file
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,10,CH) ON(22,1,CH) LASTDUP
/*
How does this know that the
Howard Brazee wrote:
How does this know that the duplicated column that I care about is column
21?
I guess I don't understand what you're trying to do. For the records you
showed,
you were treating records with 'N' in 22 as duplicates even though they had
different
characters in 21 ('*' and
17 matches
Mail list logo