Re: sql insert without duplicate keys

[Jack Tucky <jacktucky@xxxxxxxxx>]

Thank you.  I have another question.

This delete statement works, how can I change it to insert records in
invdww/locctn00.  I need to join locctn00 in the select statement somehow.

Thanks

delete
from invdww/locctn00 lc where exists
(select * from  invdww/locplt00 lp
where shp=50113 and lp.rid=lc.rid and lp.plt=lc.plt  )

On Sun, Jun 14, 2015 at 5:50 PM, Glenn Gundermann <
glenn.gundermann@xxxxxxxxx> wrote:

> Use the MERGE statement.
>
> -----Original Message-----
> From: Jack Tucky <jacktucky@xxxxxxxxx>
> Sender: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>Date: Sun, 14 Jun
> 2015 16:32:48
> To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxx>
> Reply-To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: sql insert without duplicate keys
>
> I am running a statement like this for multiple files.
>
> How can I eliminate copying records that already exist in the destination
> file?  There are additional key fields besides SHP.
>
>
>
> INSERT INTO INVTO/skusum
> SELECT * FROM INVFROM/skusum  WHERE shp = 12345
>
> Thanks, Jack
> --
> 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.