The following restrictions apply to CLOB fields:

  • The UNDEFINED code page is not allowed for CLOB values.
  • You must copy a CLOB to a LONGCHAR in order to read or edit it.
  • The size limit for a CLOB is 1GB.
  • You cannot use CLOB values in an index.
  • You cannot have an array of CLOB fields.
  • You cannot pass a CLOB as a parameter (but you can pass a temp-table that contains a CLOB field as a parameter).
  • CLOB fields are only allowed in temp-tables that are NO-UNDO.
  • You cannot define a local program variable as a CLOB.
  • You cannot use ASSIGN triggers for a CLOB field.
  • You cannot use BUFFER-COMPARE on a CLOB field.
  • The initial value for a CLOB must be the Unknown value (?).
  • The RAW-TRANSFER statement skips CLOB fields, assigning the Unknown value (?) to the CLOB field in the target record.