RE: SQL INSERT Duplicates

Yes, you could use a NOT EXISTS (Select * from target_db x where 
x.key1=source.key1 and x.key2=source.key2 .....) in your WHERE clause.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Michael Ryan
Sent: Wednesday, May 31, 2006 12:25 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL INSERT Duplicates


Thanks Vern....yeah, PRPBHNODUP is empty before the INSERT statement.

I wonder if I'm doing this wrong...I still have dups, though the record
count is less in the INSERTed into file. Is there a way to only insert one
record where key values are duplicated? Like only the first customer record
if there are multiple customer records (same customer number key) in the
file.


On 5/31/06, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:

INSERT does not clear - are there records in PRPBHNODUP already? If so,
you have a couple options - DELETE from PRPBHNODUP first (or CLRPFM) or add
a WHERE clause to the subquery's SELECT that checks for existing records
based on whatever columns are pertinent.

HTH
Vern

-------------- Original message --------------
From: "Michael Ryan" <michaelrtr@xxxxxxxxx>

Why won't this only insert non-duplicate records?

insert INTO MICHAEL/PRPBHNODUP SELECT DISTINCT * FROM prpbh

I get all the records, even though I can clearly see dups...
--
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.

--
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.