As was true with TDA beta 2.5.0.878, 2.5.1 seems to no longer use fully qualified names appropriately against Netezza (using the official Netezza ODBC drivers).
Thiswas not the case with the TDA 2.5.0 just previous to this most recent version.
So when in Database explorer and a table is selected and then the data tab is picked, the sql issued to get the datain the last beta version was…
select * from database.owner.table;
Now TDA is issuing…
select * from database.table;
This obviously does not work as the database is expecting either the former or 2 dots in the expression a la…
select* from database…tablename;
And yes I’ve tried checking “Use fully qualified object names” in options>explorer>general.
Witheverything else the same (netezza drivers and versions, etc) and just this update for TDA 2.5.1, this problem now occurs. It was not in 2.5.0.
Is there some way to force TDA 2.5.1 to either use 2 dots or the true FQON?
E