Problem Note 50275: An error occurs when you use DATETIME literals with SAS/ACCESS® Interface to ODBC with a DB2 data source using a DB2 client version 9.7
 |  |  |  |  |
The following error occurs when you use a DATETIME literal in a query with SAS/ACCESS Interface to ODBC against a DB2 data source using a DB2 client version 9.7 or later:
ERROR: CLI cursor extended fetch error: [IBM][CLI Driver][DB2/NT64] SQL0180N
The syntax of the string representation of a datetime value is incorrect.
SQLSTATE=22007
Prior to DB2 9.7, the DB2 TIMESTAMP data type could hold three digits of fractional seconds (for example, 12:34:56.123). With DB2 9.7, however, IBM increased the number of fractional seconds to 12 digits, which means that the SAS/ACCESS Interface to ODBC engine needs to accommodate this change.
To circumvent this issue, use DB2 client version 9.5 or another version earlier than 9.7 that does not contain this change for the TIMESTAMP data type.
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 ODBC | 64-bit Enabled HP-UX | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Ultimate x64 | 9.3 TS1M2 | |||
| Windows Vista | 9.3 TS1M2 | |||
| Windows Vista for x64 | 9.3 TS1M2 | |||
| 64-bit Enabled AIX | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M2 | |||
| Windows 7 Professional x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Windows 7 Professional 32 bit | 9.3 TS1M2 | |||
| Windows 7 Home Premium x64 | 9.3 TS1M2 | |||
| Windows 7 Home Premium 32 bit | 9.3 TS1M2 | |||
| Windows 7 Enterprise x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 9.3 TS1M2 | |||
| Microsoft Windows XP Professional | 9.3 TS1M2 | |||
| Microsoft Windows Server 2012 Std | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2012 Datacenter | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 R2 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 | 9.3 TS1M2 | |||
| Microsoft Windows 8 Enterprise 32-bit | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Enterprise x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Pro 32-bit | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Pro x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M2 | |||
| Microsoft® Windows® for x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 9.3 TS1M2 | 9.4 TS1M0 | ||
| HP-UX IPF | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Linux | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Linux for x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Solaris for x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||