MapGraphicDescribe CLI/ODBC and IBM data server driver IBM data server driver configuration keyword
Controls the SQL data type returned when GRAPHIC, VARGRAPHIC, and LONGVARGRAPHIC columns and parameter markers are described.
- db2cli.ini keyword syntax:
- MapGraphicDescribe = 0 | 1 | 2
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="MapGraphicDescribe" 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 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 MapGraphicDescribe as follows:
- 0 - to return the default SQL data types
- 1 - to 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 - to 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 MapGraphicDescribe:
SQLDescribeCol()SQLDescribeParam()SQLGetDescField()SQLGetDescRec()SQLProcedureColumns()SQLSpecialColumns()