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

A fix for this issue for SAS/ACCESS Interface to ODBC 9.3_M2 is available at: