Micro Focus Visual COBOL 2.3 for Visual Studio 2012 > Programming > Data Access > Database Connectors > Database Connectors Reference > Configuration Variables > A_DB2_USE_CHAR_FOR_BINARY configuration variable

A_DB2_USE_CHAR_FOR_BINARY configuration variable

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

Some data sources have restrictions on the number of binary large objects (BLOBs) that can be placed into a single table. If your data source has such restrictions, specify A_DB2_USE_CHAR_FOR_BINARY in the ACUFH configuration file. Possible values for this variable are:

0	use BINARY type
1	use CHAR type

A nonzero value for A_DB2_USE_CHAR_FOR_BINARY lets you store data that uses the BINARY XFD directive as hexadecimal encoded CHAR types. This lets you work around your data source restriction. While the default value is 0 (off, false, no), this variable can also take values of On (true, yes).

Because of current limitations of the interface, you must set this variable to 1, or the database returns an error on file creation. This has been set for you in the sample ACUFH configuration filecblconfig.db2. Do not change this setting.

Example

A_DB2_USE_CHAR_FOR_BINARY 1