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 ".
>
> Thanks.
> _______________________________________________
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com