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