Re: SQL INSERT Duplicates

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

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.