RE: [sqr-users] SQR Help

["R Gumbo" <rgumbo@cottco.co.zw>]

I suggest you have aa number of procedures to handle this

Procedure one select column value from schema number one

procedure two select column value from second schema 
where the column value is equal to the one found by procedure one

procedure number three deletes rows found in procdure two
and is called from procedure number two

Then do the same now driving from  schema number two

-----Original Message-----
From: sqr-users-bounces+rgumbo=cottco.co.zw@sqrug.org
[mailto:sqr-users-bounces+rgumbo=cottco.co.zw@sqrug.org]On Behalf Of
Melissa Teator
Sent: Wednesday, January 10, 2007 8:16 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR Help


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


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