Oracle-L: RE: Out of topic :Compare 2 data files in unix

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Wed, 19 Jun 2002 06:13:31 -0800
Message-ID: <F001.0048112F.20020619061331@fatcity.com>

Manoj:

This is a simple data file comparison process. Both files must be sorted on some key value.

Now if this is a relational database, the process is somewhat easier. If just files,

Read file 1 master file
Read file 2 transaction file
If record in both, write to separate file.
If file 2> file 1, then file 1 meets your requirements.
If file 1> file 2, then file 1 meets your requirements.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:	(248) 865-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com
Web:	www.compuware.com

-----Original Message-----
[mailto:cosltemp-g.manoj_at_orbitech.co.in]

Sent:	Wednesday, June 19, 2002 3:13 AM
To:	Multiple recipients of list ORACLE-L
Subject:	Out of topic :Compare 2 data files in unix

<< File: BDY.RTF >> Hi,

I have 2 data files file1 & file2.
I want to get all those records which are present only in file2 & not in file1.
Also want records which are present in both ,separately. I tried to use diff , but not entirely familiar with the diff options.

Thanks
Manoj.

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Karniotis, Stephen
INET: Stephen_Karniotis_at_compuware.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 19 2002 - 09:13:31 CDT