Problem Note 46792: Using DEFER=YES in a Netezza LIBNAME statement turns off in-database processing of Base SAS® procedures
Using the LIBNAME engine with SAS/ACCESS® Interface to Netezza with one of the following procedures might result in an error.
- PROC MEANS/SUMMARY
- PROC FREQ
- PROC REPORT
- PROC TABULATE
- PROC REPORT
- PROC REPORT
The error, shown below, occurs when the DEFER=YES option is included in the LIBNAME statement. Rather than the majority of the processing being done within Netezza, SAS retrieves the rows from the table and processes the procedure itself. This might result in a performance issue.
ERROR: Requested function is not supported.
Also, the following warning might appear in the SAS log if the system option MSGLEVEL = I was set:
WARNING: SQL generation is not possible because incompatible dataset
options such as OBS, FIRSTOBS or GENERATION have been specified.
Currently, the only workaround is to remove the DEFER=YES option from the LIBNAME statement.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Netezza | Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows XP Professional | 9.3 TS1M0 | |
| Windows 7 Enterprise 32 bit | 9.3 TS1M0 | |
| Windows 7 Enterprise x64 | 9.3 TS1M0 | |
| Windows 7 Home Premium 32 bit | 9.3 TS1M0 | |
| Windows 7 Home Premium x64 | 9.3 TS1M0 | |
| Windows 7 Professional 32 bit | 9.3 TS1M0 | |
| Windows 7 Professional x64 | 9.3 TS1M0 | |
| Windows 7 Ultimate 32 bit | 9.3 TS1M0 | |
| Windows 7 Ultimate x64 | 9.3 TS1M0 | |
| Windows Vista | 9.3 TS1M0 | |
| Windows Vista for x64 | 9.3 TS1M0 | |
| 64-bit Enabled AIX | 9.3 TS1M0 | 9.4 TS1M0 |
| 64-bit Enabled HP-UX | 9.3 TS1M0 | 9.4 TS1M0 |
| 64-bit Enabled Solaris | 9.3 TS1M0 | 9.4 TS1M0 |
| HP-UX IPF | 9.3 TS1M0 | |
| Linux | 9.3 TS1M0 | |
| Linux for x64 | 9.3 TS1M0 | 9.4 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-06-15 16:04:09 |
| Date Created: | 2012-06-12 16:21:31 |
