JDBC AS/400 Adapter - Join Fails

, ,
1

Hello,

I am new to wm and am attempting to use a join with the JDBC adapter to an AS/400.

When the wizard creates the sql, it is not attaching the alias (t1,t2,…) to the file name. Then it squaks that t1 is undefined, see below.

“SELECT SITECODE,ITEMPREFIX,ITEMSUFFIX,ITEMNO,ITEMTYPE,REVCODE,BATCHSIZE FROM NBTYS20.WEBMFGLIB.TFRMMSTR, NBTYS20.WEBMFGLIB.TFRMDET WHERE (t1.SITECODE = t2.SITECODE)”. "

(42703/-5001) [SQL5001] Column qualifier or table T1 undefined.

Thanks,
Tog

2

Hi Tog,

Are you using a custom SQL template or a select SQL template?

Regards,
kiranj

3

I am using the standard select.

4

Did you ever find a solution to this? We just installed IS and got the adapters set up. A normal select works fine, but a join fails as it doesn’t enter the table alias on any of the select fields or the tables in the join.

I suppose I can copy the generated select statement and fix the errors, but isn’t there a better way?

Thanks!

5

There is a JDBC patch which fixes this error.