Problem Note 38214: Data that contains missing values is not written properly to the DB2 database
 |  |  |  |
Using SAS/ACCESS® Interface to ODBC to access DB2 with the iSeries ODBC driver, a SAS data set that contains missing values might not be written properly to the new DB2 table. For example, consider the following SAS data set that has a missing value:
x1 x2
1 2
1 1
1 2
2
2 1
2 1
A DATA step to write that data to DB2, using SAS/ACCESS® Interface to ODBC and the iSeries ODBC driver, completes successfully, but the data in the DBMSs table might result in the following:
x1 x2
1 2
1 1
1 2
2
1
2 1
You can correct this behavior by using the LIBNAME statement with the INSERTBUFF=1 option:
libname mylib odbc user=db2-user pwd=,em>db2-password dsn=iSeries-data-source-name
schema=db2-schema-name insertbuff=1;
You can also get correct results by using the IBM DB2 ODBC driver.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | Windows Vista | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | |||
| Type: | Problem Note |
| Priority: | low |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> ODBC (Open Database Connectivity) |
| Date Modified: | 2010-10-25 13:09:41 |
| Date Created: | 2009-12-18 11:30:23 |