Specifies the default C type of TIME columns and parameter
markers.
- db2cli.ini keyword syntax:
- MapTimeCDefault = 0 | 1 | 2
- 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.
DB2 Version 9.7 for Linux, UNIX, and Windows