Desktop productivity for business analysts and programmers

Viewing a DataSet in a Netezza Library

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Viewing a DataSet in a Netezza Library

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.

 

 


Accepted Solutions
Solution
‎09-21-2016 03:05 PM
Occasional Contributor
Posts: 10

Re: Viewing a DataSet in a Netezza Library

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.

 

 

 

View solution in original post


All Replies
Super User
Posts: 3,233

Re: Viewing a DataSet in a Netezza Library

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

 

 

Solution
‎09-21-2016 03:05 PM
Occasional Contributor
Posts: 10

Re: Viewing a DataSet in a Netezza Library

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.

 

 

 

Super User
Posts: 3,233

Re: Viewing a DataSet in a Netezza Library

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 414 views
  • 1 like
  • 2 in conversation