Some varying-length string data types cannot be referenced in certain contexts.
The following varying-length string data types cannot be referenced in certain contexts:
| Context of usage | LOB (CLOB, DBCLOB, or BLOB) |
|---|---|
The CREATE INDEX statement![]() |
Not allowed![]() |
| The definition of primary, unique, and foreign keys | Not allowed |
| Parameters of built-in functions | Some functions that allow varying-length character strings, varying-length graphic strings, or both types of strings as input arguments do not support CLOB or DBCLOB strings, or both as input. See the description of the individual functions in Built-in functions for the data types that are allowed as input to each function. |