Re: JDBC SQL problem

[Patrick L Archibald <Patrick.Archibald@xxxxxxxxxxxxx>]

Try adding the library to the column name or my favorite, assign each 
file a letter.


Select som.sompflm000.phonenum, som.sompflm010.billname from som.sompflm000
join som.sompflm010
on som.sompflm000.phonenum = som.sompflm010.phonenum

OR


Select a.phonenum, b.billname from som.sompflm000 as a
join som.sompflm010 as b
on a.phonenum = b.phonenum



Hope this helps.

Thanx, PLA



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?