DB2 Version 9.7 for Linux, UNIX, and Windows

Graphic CLI/ODBC 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
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.