Problem Note 59877: When you run PROC DATASETS on a Netezza library, results are not displayed and you see "WARNING: No matching members in directory" in the log
 |  |  |  |  |
When you use SAS® 9.4 TS1M3 in a 64-bit Windows environment, the DATASETS procedure might fail to list, modify, or delete tables in the Netezza library.
For example, this problem occurs when you perform steps similar to the following:
- Submit a LIBNAME statement to Netezza and do not specify SCHEMA=.
- Run PROC DATASETS on the Netezza library.
- Look in the SAS® log. You might see something similar to the following:
libname nzlib netezza server=nz-server user=user-ID pwd=password database=nz-db;
proc datasets lib=nzlib;
NOTE: Writing HTML Body file: sashtml.htm
WARNING: No matching members in directory.
quit;
NOTE: Writing HTML Body file: sashtml.htm
WARNING: No matching members in directory.
quit;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | Microsoft® Windows® for x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 9.4_M3 | 9.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
A fix for this issue for SAS/ACCESS Interface to Netezza 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z29.html#59877
When you use SAS® 9.4 TS1M3 on 64-bit Windows operating environments, PROC DATASETS fails to list, modify, or delete tables in the Netezza library.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-02-16 13:43:33 |
| Date Created: | 2017-02-02 12:07:40 |