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.
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.
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
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.
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.
⏰
Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.
Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.