RE: DB2 SQL problem -- Urgent help needed

["Richards, Etienne (CAP, PTL)" <Etienne.Richards@xxxxxxxxxx>]

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.