TimestampDefaultDescribeMapping IBM data server driver configuration keyword
Controls the SQL data type that is returned when TIMESTAMP columns and parameter markers are described.
- Equivalent CLI keyword
- MapTimestampDescribe
- Equivalent IBM® data server provider for .NET connection string keyword
- N/A
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="TimestampDefaultDescribeMapping" value="0 | 1 | 2"/>
- Default setting:
- The default SQL data type for TIMESTAMP data is returned.
- In ODBC 2.0, the default SQL data type for TIMESTAMP data is SQL_TIMESTAMP.
- In ODBC 3.0, the default SQL data type for TIMESTAMP data is SQL_TYPE_TIMESTAMP.
- Usage notes:
- To control the SQL data type that is returned when TIMESTAMP columns and parameter markers are described, set the TimestampDefaultDescribeMapping keyword 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
The following functions are affected by setting the TimestampDefaultDescribeMapping keyword:SQLColumns()
SQLDescribeCol()
SQLDescribeParam()
SQLGetDescField()
SQLGetDescRec()
SQLProcedureColumns()
SQLSpecialColumns()