RE: DB2 SQL problem -- Urgent help needed

The SQL statements are used in Java program using JDBC
API,  so lib.table naming is used.

The error "[SQL0104] Token . was not valid. Valid
tokens: =. " that indicated token "." is not the dot
of lib.table.


--- "Richards, Etienne (CAP, PTL)"
<Etienne.Richards@penske.com> wrote:
> 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.
> _______________________________________________
> 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