Re: Quick SQL How to Question

No,

    I don't think this is the answer. If I run a DIFF in Unix it shows me
the records that match on the unique key, but have any elements that have
change.  CHGPFM will do a simular comparison and exception report.

        In this case while both would do the job neither meet the
specification I could do a select * from a inner join b, on x=y where
((a.fld1 <> b.fld1) or (a.fld2 <> b.fld2).............or (A.lstFld <>
B.lstFld)) . But this is messy..  Would really like something clean like
CMPPFM only in SQL ?????

     TIA,
        JMS..

----- Original Message -----
From: "Walden H. Leverich" <WaldenL@TechSoftInc.com>
To: <midrange-l@midrange.com>
Sent: Tuesday, September 17, 2002 5:30 PM
Subject: RE: Quick SQL How to Question


> What are you trying to accomplish. If you want to know where two files are
> different you could combine them into a third file and then do a
>
> select * from thirdfile group by fld1, fld2, fld3, fldlast having count(*)
> <> 2
>
> Which would show you row that are in one file and not the other.
>
> -Walden
>
>
> ------------
> Walden H Leverich III
> President
> Tech Software
> (516) 627-3800 x11
> (208) 692-3308 eFax
> WaldenL@TechSoftInc.com
> http://www.TechSoftInc.com
>
> Quiquid latine dictum sit altum viditur.
> (Whatever is said in Latin seems profound.)
>
>
>
> -----Original Message-----
> From: Jeff Silberberg [mailto:jsilberberg@mindspring.com]
> Sent: Tuesday, September 17, 2002 17:16
> To: midrange-l@midrange.com
> Subject: Quick SQL How to Question
>
>
>
>     To the List:
>
>             Anyone know of a simple way to generate in SQL the function of
> CMPPFM or a Unix Diff.. I really need SQL so that it is Transportable to a
> couple of different SQL based DBs and OS enviroments.
>
>         Thanks,
>         JMS..
> ====================
> Jeffrey M. Silberberg
> CompuDesigns, Inc.
> Atlanta, Ga. 30350-5640
> (770) 399-9464
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com To subscribe,
unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>