Re: DB2 SQL problem -- Urgent help needed

[Weining Xu <xu_weining@xxxxxxxxx>]

Same error message.


--- Larry Loen <lwloen@us.ibm.com> wrote:
>
> What happens if you try this:
>
> update mydb.table1 t1 set t1.name = (select t2.name
> from mydb.table1 t1, mydb.table2 t2 where t1.id =
> t2.id);
>
> I don't think the dot versus slash matters here.  I
> do the slash in STRSQL
> and the dot in JDBC all the time.
>
> Larry W. Loen  -   Senior Linux, Java, and iSeries
> Performance Analyst
>                           Dept HP4, Rochester MN
>
>
>
> _______________________________________________
> 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