Unicode large character strings (DBCLOB) enable you to store large amounts of Unicode data in columns.
Host Variable Formats
- OpenESQL and DB2 ECM
01 dbclob1 SQL TYPE IS DBCLOB(2M).
dbclob1 format uses the DBCLOB SQL TYPE.
- The following definition is also valid:
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.
JVM Managed Runtime
- In addition to the definitions valid for OpenESQL, the following definition is also valid for the OpenESQL
JVM Managed Runtime:
01 dbclob3 string.
JVM Managed Runtime applications have no byte limit.
For more information on using host variables with international data, see
OpenESQL Globalization Best Practices.