Bill,
Here's my take on what you are after.
I have two files:
Old one
*******
10 FRED AAAA
20 JON AAAA
30 SHEILA AAAA
40 JUNE AAAA
50 ALICE AAAA
New one
******* (changes)
10 FRED AAAA
20 JIM AAAA <<<<<<<<< changes in cols 4-9 (a relevant change)
30 SHEILA BBBB <<<<<<<<< changes in cols 12-20 (an irrelevant
change)
35 SHEILA AAAA <<<<<<<<< a new record
40 JUNE AAAA
<<<<<<<<< record '50 ALICE' deleted.
----
To follow your requirements, I want a report on any added or deleted
records, or any changed records in columns 4 to 9. I don't want any report
of lines changed in columns 12 to 20.
So, in this example, I want report of lines 20, 35, and 50.
I use 'Compare Type' = Line, and 'Listing Type' = Delta
My process statements are:
CMPCOLM 1:2 4:8
And this produces:
I - 20 JIM AAAA
D - 20 JON AAAA
I - 35 SHEILA AAAA
D - 50 ALICE AAAA
... is this what you are after?
You need to include (what you see as) your key columns in the comparison as
well. SuperC doesn't know that changes in this column are relevant unless
you tell it to. Specifying only cols 999:1005 means it will ignore changes
in any other columns - including your 'record key'. Adding this should fix
your problem, hopefully.
hth,
Mike Flint,
Systems Consultant,
Experian.
-----Original Message-----
From: George, William (DHS-ITSD) [mailto:[EMAIL PROTECTED]
Sent: 21 September 2005 21:04
To: [email protected]
Subject: Re: SUPERC Insights
Barry
Thanks for the reply.
You said, "Columns 999:1005 is length of seven, not the six you
specify."
Very true and this is what happens when I type without thinking.
Lets see if I can restate it better.
What I'm attempting to do is compare two files and;
1) report any differences found within a certain column range and
2) any added or deleted records.
I have two test files I'm working with that have 20 records each.
The files are exact until I made these changes to the one I'll call NEW
(Key is the first 9 digits of the record)
1) record key 999999999 deleted from NEW
2) record key 999999995 had data changed in cols 999-1004
3) record key 999999992 also had data changed
4) record key 999999989 was ADDED to the NEW file
RESULTS
When I execute SUPERC with no process statements the output from SUPERC
seems as I would expect (run with Compare Type = FILE Listing type =
Delta and NO process options)
D - 999999999 3J90004514W5 M38 3 ROGERS
<snipped!>
Find out about The Experian Conference 2005 at www.experian.co.uk/conference2005
==========================================================================
Information in this e-mail and any attachments are confidential, and may not be
copied or used by anyone other than the addressee, nor disclosed to any third
party without our permission. There is no intention to create any legally
binding contract or other binding commitment through the use of this electronic
communication unless it is issued in accordance with the Experian Limited
standard terms and conditions of purchase or other express written agreement
between Experian Limited and the recipient Experian Limited (registration
number 653331) Registered office: Talbot House, Talbot Street, Nottingham NG80
1TH
Although Experian has taken reasonable steps to ensure that this communication
and any attachments are free from computer virus, you are advised to take your
own steps to ensure that they are actually virus free.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
