Re: sql insert without duplicate keys

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

Hi Jack,

Sorry but I don't understand what you are trying to do.

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144




On 15 June 2015 at 10:46, Jack Tucky <jacktucky@xxxxxxxxx> wrote:

> 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