Re: JDBC SQL problem

[Dieter Bender <dieter.bender@xxxxxxxxxxxx>]

Hi,

as Patrickalready  supposed, you have to use aliasing of the file or double 
qualifieing with database.file.field

Dieter Bender

On Dienstag, 2. Dezember 2003 17:05, Glenn Holmer wrote:
> 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.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de
eMail dieter.bender@xxxxxxxxxxxx