Re: Compare two flat files

[Arun Kumar <arunkumar13@YAHOO.COM>]

Oops I didnt read this mail before replying

Sorry

Arun
--- the dragon <ceprn@HOTMAIL.COM> wrote:
> OK, what's your database?  If it is Oracle, have
> your dba establish a link
> alias between your two systems.  You won't even have
> to save the output to
> csv files unless you want to.  Then just execute the
> following code (not
> sure if you can do this in PS Query, because I am
> not sure how successfully
> it would process the link):
>
> (pseudo code follows)
>
> select
> aliasa.columns
> from (target database)table@link aliasa
> where not exists (select 1
>                   from (source database) table
> aliasb
>                   where aliasb.keys = aliasa.keys
>                  )
> and   other where clause criteria
> order by whatever
>
> This will work.  If you are using a database
> inferior to Oracle (and what
> other database isn't), talk with your dba to see how
> to set this up if it is
> possible.
>
> Another idea would be to populate the data from the
> target database into
> tables in the source database and do your compares
> there.
>
> hope this helps,
>
> clark 'the dragon' willis
> dragon enterprises, consulting services
>
>
> ----Original Message Follows----
>
> They are formatted .csv. I want as much automation
> as possible. I could
> easily do this in MS Access by bringing the files in
> there and doing a
> unmatched query but the steps I must take before
> that are too cumbersome.
> Currently to compare a file:
>
> 1.      Run PS Queries to get the different queries
> to excel - one out of
> our SFS system and one from our SA system.
> 2.      Open database in Access and bring in both of
> these excel files using
> Import.
> 3.      Run a unmatched query in access.
> 4.      Save file to csv to be able to load into SA
> the data not in there
> already.
>
> I'm going to have to do this for at least 8
> different other tables and  I
> want to make it as much automated as possible.
>
> -----Original Message-----
> From: the dragon [mailto:ceprn@HOTMAIL.COM]
> Sent: Tuesday, April 23, 2002 11:17 AM
> To: SQR-USERS@list.iex.net
> Subject: Re: Compare two flat files
>
>
> I have some information to share, but first, what is
> it you are trying to
> compare - obviously lat files, but are they
> formatted (delimitted flat file)
> or free form (sqr program).  Also, in what
> environment/OS?  How much
> automation do you want, or user intervention?
>
> clark 'the dragon' willis
> dragon enterprises, consulting services
>
>
>
_________________________________________________________________
> Send and receive Hotmail on your mobile device:
http://mobile.msn.com


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/