Unicode Large Character Strings (DBCLOB)

Host Variable Formats

OpenESQL and DB2 ECM

01 dbclob1     SQL TYPE IS DBCLOB(2M).

The dbclob1 format uses the DBCLOB SQL TYPE.

OpenESQL

The following definition is also valid:

01 dbclob2.
   49 dbclob2-len          PIC S9(9) COMP-5.
   49 dbclob2-data         PIC N(32000) USAGE NATIONAL.

• The level number for group items containing only two elementary items must be 49. The first item is a four-byte field declared with usage COMP or COMP-5 that represents the effective length of the character string. The length field can be signed or unsigned. The second item is a PICn NATIONAL data type, where n is an integer representing the length of the field that holds the data.
• SQL statements must reference the group name.

OpenESQL .NET Managed Runtime

In addition to the definitions valid for OpenESQL, the following definition is also valid for the OpenESQL .NET Managed Runtime:

01 dbclob3     string.

OpenESQL .NET Managed Runtime applications have no byte limit.

For more information on using host variables with international data, see OpenESQL Globalization Best Practices.