Can I run SQL on Netezza via WebFocus please.
I have created a define field in a synonym that accesses a Netezzza table.
I have used DB_EXPR in the define field.
DEFINE SQLTEST/I7 WITH TYPE_ID=DB_EXPR(select count(*) from database.schema.table name);
When I sample the data or try to create a report over the synonym I get the FOC1240 message.
I cannot find any log that will tell me what is wrong.
Has anybody any ideas please.
LenThis message has been edited. Last edited by: FP Mod Chuck,
Do you have a connection adapter defined for Netezza ?
See Configuring the Adapter for Netezza
WF versions : Prod 188.8.131.52M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
Thanks for the reply. Yes we do have a Netezza adapter. After talking to Tech Support I am checking with our server admin to see if Direct Passthru has been enabled.
|Powered by Social Strata|