Hi

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);
TITLE='SQLTEST', $

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.

Thanks

Len

This 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

Hi Martin

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.