Problem Note 41875: SAS/ACCESS® Interface to DB2 might produce incorrect results when left joining two or more DB2 tables
 |  |  |  |  |
SAS/ACCESS Interface to DB2 might produce incorrect results when left joining two or more DB2 tables.
The issue occurs in rare cases where column aliases are used on the SELECT clause and an additional WHERE contains a PUT() function call. For example:
libname db2lib db2 datasrc=sample user=userid password=pwd;
PROC SQL;
SELECT a.x, b.y as y_alias from db2lib.a left join db2.b on (put(b.z,1.)='9');
QUIT;
Remove the alias from the SELECT clause to circumvent the issue.
A hotfix is planned 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 DB2 | z/OS | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows XP 64-bit Edition | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft® Windows® for x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Enterprise 32 bit | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Enterprise x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Home Premium 32 bit | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Home Premium x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Professional 32 bit | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Professional x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Ultimate 32 bit | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Ultimate x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows Vista | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| HP-UX IPF | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Linux | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Linux for x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Solaris for x64 | 9.21_M2 | 9.21_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#41875
SAS/ACCESS Interface to DB2 might produce incorrect results when left joining two or more DB2 tables
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2 |
| Date Modified: | 2011-01-04 11:10:15 |
| Date Created: | 2010-12-16 03:59:27 |