What you can do with BLOB values
- Last Updated: December 3, 2025
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
What you can do with BLOB values
You can do the following with BLOB values:
- You can define a database table field or a temp-table field
as a
BLOB. - You can use the
COPY-LOBstatement to copy large object data from oneBLOBorMEMPTRto another.COPY-LOBalso handles movingBLOBorMEMPTRdata to or from the file system. For more information, see Copy large objects. - You can
EXPORTandIMPORT BLOBdata to and from disk. - You can use the
LENGTH()function on aBLOBfield to get the size of theBLOBin bytes. - The
BUFFER-COPYandBUFFER-COMPAREstatements operate onBLOBfields. ABUFFER-COPYof a record with aBLOBin it results in the creation of aBLOBfor the new record.BUFFER-COMPAREcompares the data in theBLOBfields and reports any discrepancy. To skipBLOBfields duringBUFFER-COPYandBUFFER-COMPARE, use theNO-LOBSoption. - You can use the dynamic
BUFFER-FIELD:BUFFER-VALUEfor aBLOBfield in 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 theBLOBdata type.
For examples on how to use BLOB fields in an
application, see Use large objects in ABL.