RE: Quick SQL How to Question

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I wish you luck on your quest...

one solution:

  Write a Java program...  And in that java program, retrieve from the
command line, the two system/tables you want to compare...  Do a generic
select * from... type of clause, parse through the meta data, and write two
CSV files, one for each table...  And then call your diff or compare program
from java, supplying it with the newly created csv files.  If your using a
PC, I recommend  araxis merge or examdiff,  great tools..

... I have looked over the diff.c code in the past, and I just don't think
you can create that type of functionality in a stored procedure...  It's
just too darn complex... At least the good diffs I have seen...  You have to
walk forward and backwards trying to find midpoints... ...

tim

> -----Original Message-----
> From: Jeff Silberberg [SMTP:jsilberberg@mindspring.com]
> Sent: Tuesday, September 17, 2002 2:16 PM
> 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 e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.