GraphicDefaultDescribeMapping IBM data server driver configuration keyword
Controls the SQL data type that is returned when GRAPHIC, VARGRAPHIC, and LONGVARGRAPHIC columns and parameter markers are described.
- Equivalent CLI keyword
- MapGraphicDescribe
- Equivalent IBM® data server provider for .NET connection string keyword
- N/A
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="GraphicDefaultDescribeMapping" value="0 | 1 | 2"/>- Default setting:
- The default SQL data types are returned: SQL_GRAPHIC for GRAPHIC columns, SQL_VARGRAPHIC for VARGRAPHIC columns, and SQL_LONGVARGRAPHIC for LONG VARGRAPHIC columns.
- Usage notes:
- To control the SQL data type that is returned when GRAPHIC-based columns and parameter markers are described, set GraphicDefaultDescribeMapping as follows:
- 0
- Return the default SQL data types.
- 1
- Return the CHAR-based SQL data types: SQL_CHAR for GRAPHIC columns, SQL_VARCHAR for VARGRAPHIC columns, and SQL_LONGVARCHAR for LONG VARGRAPHIC columns.
- 2
- Return the WCHAR-based SQL data types: SQL_WCHAR for GRAPHIC columns, SQL_WVARCHAR for VARGRAPHIC columns, and SQL_WLONGVARCHAR for LONG VARGRAPHIC columns.
Only the following CLI functions are affected by setting the GraphicDefaultDescribeMapping keyword:SQLDescribeCol()SQLDescribeParam()SQLGetDescField()SQLGetDescRec()SQLProcedureColumns()SQLSpecialColumns()