What you can do with CLOB values
- Last Updated: August 11, 2020
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
What you can do with CLOB values
You can do the following with CLOB values:
- You can define a database table field or a temp-table field
as a
CLOB. - When you define a field as a
CLOB, you can specify a code page for it. - You can use the
COPY-LOBstatement to copy large object data from oneCLOBorLONGCHARto another.COPY-LOBalso handles movingCLOBorLONGHARdata to or from the file system. For more information, see Copy large objects. - You can
EXPORTandIMPORT CLOBdata to and from disk. - The
BUFFER-COPYstatement operates onCLOBfields. ABUFFER-COPYof a record with aCLOBin it results in the creation of aCLOBfor the new record. Use theNO-LOBSoption if you want to skipCLOBfields duringBUFFER-COPY. - You can use the dynamic
BUFFER-FIELD:BUFFER-VALUEfor aCLOBfield in most of the same places you can use a static reference. - To determine whether the buffer has large object fields defined
in it, you can use the
HAS-LOBSattribute for aBUFFERobject. You can then check the data type of the buffer fields for theCLOBdata type.
For examples on how to use CLOB fields in an
application, see Use large objects in ABL.