Re: JDBC SQL problem

Hi,
I think that the table assignment "WIPFPD.WPWIP, WIPFPH.WPEDT" should be 
unqualified,
your library is ACSDBASE2.
Hope this helps.
Ciao.

On Tue, 02 Dec 2003 08:43:23 -0600, Glenn Holmer wrote:

>I'm building an SQL statement programmatically and running it against
>a V5R2 AS/400 (running Java 1.4.1) from a rich client running on a PC.
>I'm getting an error I don't understand.  Here's the SQL as the
>NetBeans debugger traps it:

>SELECT DISTINCT WIPFPD.WPWIP, WIPFPH.WPEDT
>FROM ACSDBASE2.WIPFPH, ACSDBASE2.WIPFPD
>WHERE WPDVN LIKE 'JI%' AND WPSTG = 3 AND WPUNT > 0
>ORDER BY WPEDT DESC

>I get the error "[SQL5001] Column qualifier or table WIPFPD undefined."
>But if I cut 'n' paste that same SQL into STRSQL in a 5250 terminal
>(changing lib.file to lib/file), it runs just fine.  

>Anybody have any ideas why that might be?

>-- 
>____________________________________________________________
>Glenn Holmer                          gholmer@xxxxxxxxxxxxxx
>Programmer/Analyst                       phone: 414.908.1809
>Weyco Group, Inc.                          fax: 414.908.1601

>_______________________________________________
>This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
>mailing list
>To post a message email: JAVA400-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/java400-l
>or email: JAVA400-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/java400-l.



-----------------------------------------------------------------------------
*** This messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne