Gurus,
We are migrating our SAS server and upgrading from 9.3 to 9.4. We use SAS/Access for Netezza and when we create LIBNAMES for our Netezza data and try to drag and drop and open a Netezza dataset we get an error on the SQL run in Netezza. The SQL has TWO LIMIT clauses.
SAS Enterprise Guide cannot open the data file: "Libref.tablename"
[Error} CLI open cursor error: ERROR: 'SELECT * FROM DB.schema.tablename LIMIT 500 limit 500' error
^ found "LIMIT" (at char44) expecting a keyword
We do ask our users to set the Maximum number of rows to display in the data grid to 500. (Tools -> Options -> Data -> Performance).
When this option is changed (to 100), both LIMIT clauses change. When we change it to 0, we don't get the error -- but most of our netezza tables are much too large to NOT have a limit clause! We ask our users not to open the data sets, but... users will be users!
Current libname statement:
libname netezza server=&nzSERVER. database=&nzDATABASE. schema=&nzSCHEMA. user=&msUSERID. password=&msPASSWORD. connection=globalread defer=yes;
Is there another setting? Something I can add to the libname?
Query Builder works fine.
Screen prints of settings and errors are attached
Any ideas are GREATLY appreciated!