× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.