Re: File Comparision

[Narayanan Pillai <strqst400@xxxxxxxxx>]

SQL not exists clause

Pillai

Sent from my iPad

> On Dec 4, 2013, at 10:10 PM, Vinay Gavankar <vinaygav@xxxxxxxxx> wrote:
>
> Hi,
>
> I have 2 files, FILEA and FILEB, which have exactly same format, about 20
> fields each and the total length of the record is less than 200 bytes.
>
> FILEB is a subset of FILEA.
>
> What is the simplest way of getting a file with records in FILEA not
> present in FILEB?
>
> Working on a development box, so I am free to create temporary files from
> these 2, as the number of records in these files is not very high.
>
> I may have to repeat this a few times so trying to figure the simplest
> solution.
>
> TIA
> Vinay
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.