Controls the SQL data type returned when TIMESTAMP columns and
parameter markers are described.
- db2cli.ini keyword syntax:
- MapTimestampDescribe = 0 | 1 | 2
- Default setting:
- The default SQL data type for TIMESTAMP data is returned: SQL_TIMESTAMP
for ODBC 2.0 or SQL_TYPE_TIMESTAMP for ODBC 3.0.
- Usage notes:
-
To control the SQL data type that is returned when TIMESTAMP columns
and parameter markers are described, set MapTimestampDescribe as follows:
- 0 - to return the default SQL data type: SQL_TIMESTAMP for ODBC 2.0 or
SQL_TYPE_TIMESTAMP 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 MapTimeStampDescribe:
- SQLColumns()
- SQLDescribeCol()
- SQLDescribeParam()
- SQLGetDescField()
- SQLGetDescRec()
- SQLProcedureColumns()
- SQLSpecialColumns()
DB2 Version 9.7 for Linux, UNIX, and Windows