CLOB

An item of type CLOB represents a character large object with a length ranging from one byte to two gigabytes.

The following statements are true of an item of type CLOB:
  • It can be declared only as an individual item, and is not supported in BasicRecords.
  • It can be passed to local function and program calls. Large object parameters and corresponding arguments must both be declared as large objects of the same type.
  • It can be assigned only to another Clob variable.
  • It can be moved to another Clob variable, which has the same result as being assigned to a Clob variable.
  • You can create a reference variable of BLOB.
  • It uses SQLlocator (CLOB); that is, CLOB contains a logical pointer to the SQL CLOB data rather than to the data itself.
  • When used with SQLRecord,
    • CLOB represents Character Large Object as a column in the database.
    • CLOB is valid for the duration of the transaction in which it was created.
  • It cannot be passed to calls to remote programs or to non-EGL programs.
  • It cannot be referenced as an operand on assignment statements or in expressions.
You may use the following functions with CLOB:
  • attachClobToFile
  • freeClob
  • getClobLen
  • getStrFromClob
  • getSubStrFromClob
  • loadClobFromFile
  • setClobFromString
  • setClobFromStringAtPosition
  • truncateClob
  • updateClobToFile
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.