MIDRANGE dot COM Mailing List Archive

Re: DB2 SQL problem -- Urgent help needed


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

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact