MapDateDescribe CLI/ODBC and IBM data server driver configuration keyword

Controls the SQL data type returned when DATE columns and parameter markers are described.

db2cli.ini keyword syntax:
MapDateDescribe = 0 | 1 | 2
IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
<parameter name="MapDateDescribe" 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 SQL data type for DATE data is returned: SQL_DATE for ODBC 2.0 or SQL_TYPE_DATE for ODBC 3.0.
Usage notes:
 
To control the SQL data type that is returned when DATE columns and parameter markers are described, set MapDateDescribe as follows:
  • 0 - to return the default SQL data type: SQL_DATE for ODBC 2.0 or SQL_TYPE_DATE for ODBC 3.0
  • 1 - to return the SQL_CHAR SQL data type
  • 2 - to return the SQL_WCHAR SQL data type
Only the following CLI functions are affected by setting MapDateDescribe:
  • SQLColumns()
  • SQLDescribeCol()
  • SQLDescribeParam()
  • SQLGetDescField()
  • SQLGetDescRec()
  • SQLProcedureColumns()
  • SQLSpecialColumns()