SQL Error via ODBC but not in Command Center

[Michael Lueck]

If I issue the following SQL in the script center...

SELECT NULLID.PRODTEXT.TEXT
FROM NULLID.PAGES,NULLID.PAGEPRODLINK,NULLID.PRODUCTS,N ULLID.PRODTEXT
WHERE (((((NULLID.PAGES.ID = '00000020' )
AND (NULLID.PAGES.ACTIVEFLAG = '1' ) )
AND (NULLID.PAGES.ID = NULLID.PAGEPRODLINK.PAGEID ) )
AND (NULLID.PAGEPRODLINK.PRODID = NULLID.PRODUCTS.PRODID ) )
AND (NULLID.PRODUCTS.PRODID = NULLID.PRODTEXT.PRODID ) )
ORDER BY NULLID.PRODTEXT.SORTORDER

it returns the desired rows. I copied this SQL directly from the ODBC log I generated where it errors as follows...

[IBM][CLI Driver][DB2/NT] SQL0204N "NULLID.PAGEPRODLINK" is an undefined name. SQLSTATE=42704

This is DB2 6.1 FP11 on Win2K.

Is there some issue in this version of the ODBC driver which I need to work around, such as dividing this into two queries?

--
Michael Lueck
Lueck Data Systems

Remove the upper case letters NOSPAM to contact me directly.

[Michael Lueck]

Found it... I had forgotten a hard coded path in the program and when it went prod it was still looking at the test config file, thus off to test databases, etc...
--
Michael Lueck
Lueck Data Systems

Remove the upper case letters NOSPAM to contact me directly.