topic Re: Viewing a DataSet in a Netezza Library in SAS Enterprise Guide

Viewing a DataSet in a Netezza Library

ToddS — Wed, 14 Sep 2016 15:29:26 GMT

I am able to connect to a Netezza database using a libname statement. In the servers window I can see the tables in that library. I used to be able to double click on a table and it opened up in SAS. I am using EG 7.12. Now when ever I double click on a table I get the following error:

SAS Enterprise Guide cannot open the data file: "NETSND.ADULT". [Error] CLI open cursor error: ERROR: 'SELECT * FROM AA_INZA_SND..ADULT LIMIT 10000 limit 10000' error found "LIMIT" (at char 46) expecting a keyword.

So it sounds like the underlying code in repeating the limit statement twice. How do we fix that?

The work around is to use Query Builder directly to create SQL code to view the data. But I rather go back to just double clicking!

Any help you give me would be great.

Re: Viewing a DataSet in a Netezza Library

SASKiwi — Wed, 14 Sep 2016 23:59:10 GMT

Looks like you might have struck this problem. There is a hot fix available for SAS 9.4M3.

http://support.sas.com/kb/58/291.html

Re: Viewing a DataSet in a Netezza Library

ToddS — Wed, 21 Sep 2016 19:05:14 GMT

It turns out that my problem did not require the hotfix referenced. All I had to do was change the following option:

Data > Performance > Maximum number of rows to display in the data grid with SAS/ACCESS data: > no limit

I originally had it limited to 100,000 rows so the SQL generated added a limit of 100,000 but the Netezza Access code also added a limit 100,000 so the code would bomb. Now it works and the dataset opens.

Re: Viewing a DataSet in a Netezza Library

SASKiwi — Wed, 21 Sep 2016 19:27:58 GMT

I did think about that as a workaround too, but if you want to switch back to limiting again you will need the hot fix.