Problem Note 62913: Incorrect results occur after you apply Hot Fix C9E001 or Hot Fix A7C003 to SAS/ACCESS® Interface to Netezza
 |  |  |  |  |
Under the following conditions, you encounter incorrect results after you apply Hot Fix A7C003 (SAS® 9.4 TS1M4) or Hot Fix C9E001 (SAS® 9.4 TS1M5):
- The Netezza table contains variables that are defined as VARCHAR or NVARCHAR data types.
- Your query has a mixture of rows that contain values and rows that contain blanks (not nulls).
- The LIBNAME statement (or CONNECT TO NETEZZA statement if using explicit pass-through) does not include READBUFF=0.
- More than one row is returned.
- The rows with blanks are not read in before the rows with values.
The workaround for this issue is to add READBUFF=0 to your code. Although this workaround should ensure that correct results are read from Netezza, it might result in slower performance.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | Microsoft® Windows® for x64 | 9.4 TS1M4 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M4 | |||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M4 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M4 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.4 TS1M4 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Linux for x64 | 9.4 TS1M4 | 9.4 TS1M6 | ||
A fix for this issue for SAS/ACCESS Interface to Netezza 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C9E.html#62913A fix for this issue for SAS/ACCESS Interface to Netezza 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A7C.html#62913
Under certain circumstances, you encounter incorrect results after you apply Hot Fix C9E001 (SAS® 9.4 TS1M5) or Hot Fix A7C003 (SAS® 9.4 TS1M4).
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2019-01-02 13:43:50 |
| Date Created: | 2018-09-13 10:43:09 |