Graphic CLI/ODBC and IBM data server driver configuration keyword
Specifies if CLI returns SQL_GRAPHIC (double-byte character) as a supported SQL data type and what unit is used to report GRAPHIC column length.
- db2cli.ini keyword syntax:
- Graphic = 0 | 1 | 2 | 3
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="Graphic" value=“0 | 1 | 2 | 3"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- The SQL_GRAPHIC data type is not returned as a supported SQL data type, and the length of GRAPHIC columns equals the maximum number of DBCS characters in the column.
- Usage Notes:
The Graphic keyword controls whether the SQL_GRAPHIC (double-byte
character) data type is reported as a supported SQL data type when SQLGetTypeInfo() is called, as well as what unit is used to report the length
of GRAPHIC columns for all CLI functions that return length or precision as either output
arguments or as part of a result set.
Set the Graphic keyword as follows:
- 0 - SQL_GRAPHIC is not returned as a supported SQL data type, and the reported length of GRAPHIC columns equals the maximum number of DBCS characters in the column.
- 1 - SQL_GRAPHIC is returned as a supported SQL data type, and the reported length of GRAPHIC columns equals the maximum number of DBCS characters in the column.
- 2 - SQL_GRAPHIC is not returned as a supported SQL data type, and the reported length of GRAPHIC columns equals the maximum number of bytes in the column.
- 3 - SQL_GRAPHIC is returned as a supported SQL data type, and the reported length of GRAPHIC columns equals the maximum number of bytes in the column.