Re: DB2 SQL problem -- Urgent help needed

I had problems with the update from a subselect when the file with the new data 
is not one
to one with the old.  In that case, you need to update only the records that 
have a match,
or set the field as "null capable", in this case you may loose data.

Someting like this:

update t1 set data1 = (select data2 from t2 where key2 = t1.key2) where key1 in 
(select
key2 from t2)
________________________________________________________________________________
Weining Xu wrote:

> Yes, all simple update, insert, delete statements
> works.  So far only subselect inside an update
> statement does not work.
> --- "Clapham, Paul" <pclapham@core-mark.com> wrote:
> > Have you already tried just plain "set name = ..."?
> >
> > PC2
> >
> > -----Original Message-----
> > From: Weining Xu [mailto:xu_weining@yahoo.com]
> > Sent: June 6, 2002 09:00
> > To: java400-l@midrange.com
> > Subject: Re: DB2 SQL problem -- Urgent help needed
> >
> >
> > I tried both slash and dot in both strsql and
> > Operations Navigator.  The error is the same.
> >
> > strsql tells that Token dot error occors at "set
> > t1.name ".