Problem Note 44333: When you use DELETE_MULT_ROWS= or UPDATE_MULT_ROWS= with SAS/ACCESS® Interface to Greenplum, some rows are not deleted or updated
 |  |  |  |  |
When you use the LIBNAME options DELETE_MULT_ROWS=YES or UPDATE_MULT_ROWS=YES with SAS/ACCESS Interface to Greenplum, unexpected results might occur: Some of the rows that are affected by the SQL statement might not be deleted or updated.
This could lead to additional unexpected results for subsequent actions on the table.
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 Greenplum | Windows 7 Enterprise 32 bit | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 |
| Solaris for x64 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Linux for x64 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Linux | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| HP-UX IPF | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled Solaris | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled AIX | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Enterprise x64 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP Professional | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft® Windows® for x64 | 9.3 | 9.3_M1 | 9.3 TS1M0 | 9.3 TS1M1 | ||
A fix for this issue for SAS/ACCESS Interface to Greenplum 9.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F17.html#44333| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> GreenPlum |
| Date Modified: | 2011-10-27 09:21:54 |
| Date Created: | 2011-09-19 11:28:23 |