MapTimeCDefault CLI/ODBC and IBM data server driver configuration keyword

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

db2cli.ini keyword syntax:
MapTimeCDefault = 0 | 1 | 2
IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
<parameter name="MapTimeCDefault" value="0 | 1 | 2"/>
Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
Default setting:
The default C type representation for TIME data is SQL_C_TYPE_TIME.
Usage notes:
 
MapTimeCDefault controls the C type that is used when SQL_C_DEFAULT is specified for TIME columns and parameter markers. This keyword should be used primarily with Microsoft applications, such as Microsoft Access, which assume SQL_C_CHAR as the default C type for datetime values. Set MapTimeCDefault as follows:
  • 0 - for the default SQL_C_TYPE_TIME C type representation: a struct containing numeric members for hour, minute, and second
  • 1 - for an SQL_C_CHAR C type representation: "12:34:56"
  • 2 - for an SQL_C_WCHAR C type representation: "12:34:56" in UTF-16.
This keyword affects the behavior of CLI functions where SQL_C_DEFAULT may be specified as a C type, such as SQLBindParameter(), SQLBindCol(), and SQLGetData().
Note: MapTimeCDefault supersedes Patch2=24. If both MapTimeCDefault and Patch2=24 are set, the MapTimeCDefault value takes precedence.