TimeDefaultDescribeMapping IBM data server driver configuration keyword

Controls the SQL data type that is returned when TIME columns and parameter markers are described.

Equivalent CLI keyword
MapTimeDescribe
Equivalent IBM® data server provider for .NET connection string keyword
N/A
IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="TimeDefaultDescribeMapping" value="0 | 1 | 2"/>
Default setting:
The default SQL data type for TIME data is returned.
  • In ODBC 2.0, the default SQL data type for TIME data is SQL_TIME.
  • In ODBC 3.0, the default SQL data type for TIME data is SQL_TYPE_TIME.
Usage notes:
To control the SQL data type that is returned when TIME columns and parameter markers are described, set the TimeDefaultDescribeMapping keyword as follows:
  • 0 - to return the default SQL data type: SQL_TIME for ODBC 2.0 or SQL_TYPE_TIME for ODBC 3.0
  • 1 - to return the SQL_CHAR SQL data type
  • 2 - to return the SQL_WCHAR SQL data type
The following functions are affected by setting the TimeDefaultDescribeMapping keyword:
  • SQLColumns()
  • SQLDescribeCol()
  • SQLDescribeParam()
  • SQLGetDescField()
  • SQLGetDescRec()
  • SQLProcedureColumns()
  • SQLSpecialColumns()