TimestampDefaultCMapping IBM data server driver configuration keyword

Specifies the default C type of TIMESTAMP columns and parameter markers.

Equivalent CLI keyword
MapTimestampCDefault
Equivalent IBM® data server provider for .NET connection string keyword
N/A
IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="TimestampDefaultCMapping" value="0 | 1 | 2"/>
Default setting:
The default C type representation for TIMESTAMP data is SQL_C_TYPE_TIMESTAMP.
Usage notes:
The TimestampDefaultCMapping keyword controls the C type that is used when SQL_C_DEFAULT is specified for TIMESTAMP columns and parameter markers. The TimestampDefaultCMapping keyword is typically used with Microsoft applications, such as Microsoft Access, which assume SQL_C_CHAR as the default C type for datetime values. Set the TimestampDefaultCMapping keyword as follows:
  • 0 - for the default SQL_C_TYPE_TIMESTAMP C type representation: a struct that contains numeric members for year, month, day, hour, minute, second, and fraction of a second
  • 1 - for an SQL_C_CHAR C type representation: "2008-01-01 12:34:56.123456"
  • 2 - for an SQL_C_WCHAR C type representation: "2008-01-01 12:34:56.123456" in UTF-16.
This keyword affects the behavior of CLI functions where SQL_C_DEFAULT can be specified as a C type, such as SQLBindParameter(), SQLBindCol(), and SQLGetData().