Re: JDBC SQL problem

[Glenn Holmer <gholmer@xxxxxxxxxxxxxx>]

Colin Williams wrote:
> Glenn,
>
> You are running your JDBC connection with naming set to SYS, but you are
> using SQL naming in your SQL statement.
>
> SYS naming uses /
> SQL naming uses .
>
> Set the naming property on your JDBC URL to the one you are using

OK, I found how to do that and it works, but that means changing 
all the other SQL in this program.  Is there a way to correct the 
syntax so that it runs with sql naming?

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

[SQL5001] Column qualifier or table WIPFPH undefined.

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