RE: DB2 SQL problem -- Urgent help needed

Chris,

Could it be that you have different naming conventions on the two systems?
The one system might be using SQL naming while the other uses SQL naming.

System 1: lib.table
System 2: lib/table

Etienne

-----Original Message-----
From: Weining Xu [mailto:xu_weining@yahoo.com]
Sent: Thursday, June 06, 2002 9:36 AM
To: java400-l@midrange.com
Subject: RE: DB2 SQL problem -- Urgent help needed


Chris,

Could you elaborate a little about the system naming
and SQL naming?

Thanks
--- "Price, Chris" <chris_price@nsb.co.uk> wrote:
> I would suggest you check whether your using system
> naming or SQL naming.
>
>  -----Original Message-----
> From:         Weining Xu [mailto:xu_weining@yahoo.com]
> Sent: 06 June 2002 14:07
> To:   java400-l@midrange.com
> Subject:      DB2 SQL problem  -- Urgent help needed
>
> Hi all,
>
> We developed an Java program on AS400 V5R1 machine
> by
> using native DB2 JDBC driver.  Then we deploy the
> program on an AS400 V4R5 machine, also using native
> DB2 JDBC driver.  Both matchines use JDK1.2.2.  Some
> SQL statements are not working on the depolyment
> AS400. An example is update record with subselect.
> A
> simplfied SQL is:
>
> update mydb.table1 t1 set t1.name = (select t2.name
> from mydb.table2 t2 where t1.id = t2.id);
>
> I got:
> [SQL0104] Token . was not valid. Valid tokens: =.
>
> The exactly same SQL works fine on V5R1 machine.  So
> it should not be the problem of SQL. It seems like
> the
> V4R5 does not accept subselect SQL syntax, since all
> simple select, insert, update and delect are working
> fine.
>
> What could be wrong?  Does we missing any PTFs?
>
> Wayne (Weining) Xu
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> _______________________________________________
> 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.
> _______________________________________________
> 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
_______________________________________________
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.