Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL On Netezza
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] SQL On Netezza
 Login/Join
 
Member
posted
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,
 
Posts: 2 | Registered: November 21, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Do you have a connection adapter defined for Netezza ?

See Configuring the Adapter for Netezza


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2232 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
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.
 
Posts: 2 | Registered: November 21, 2019Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL On Netezza

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.