[sqr-users] RE: SQR Help

["White . Denise" <DWhite@drc.com>]

Hi Melissa,

As you already can see, there are a number of ways to do what you want.
Here is another: As someone mentioned, have your DBA create a database
link between the two databases so that you can reference both in the
same SQR.  Then just do a join between the two tables on the column you
are looking for duplicates in, selecting the keys of the table you want
to delete from.  Any rows returned are a match, and therefore a
duplicate, so you can use the returned key values to do the delete.

Denise M. White
EBS Programmer/Analyst III
Dynamics Research Corporation
------------------------------

Message: 2
Date: Wed, 10 Jan 2007 13:15:41 -0500
From: "Melissa Teator" <m_teator@sbcglobal.net>
Subject: [sqr-users] SQR Help
To: <sqr-users@sqrug.org>
Message-ID: <005b01c734e3$56c3c6c0$6401a8c0@TAGCT.local>
Content-Type: text/plain;       charset="iso-8859-1"

I am new to SQR and am trying to write a program that looks at tables 
on 2 different schemas.  Then using a column name determines if any 
rows are duplicates.  If it is a duplicate then deletes the row in one 
of the schemas.  Any idea on the best way to approach this?  I will be 
reading in table names and column names from a file.  Any help is 
appreciated!  Thanks! -M 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users