ERASE procedures

The ERASE procedures provide the capability to erase a portion of a large object.

To erase a large object means to replace the specified portion with zero-byte fillers for BLOBs or with spaces for CLOBs. The actual size of the large object is not altered.

Syntax


1  ERASE_BLOB ( lob_loc , amount?  , offset  )

1  ERASE_CLOB ( lob_loc , amount?  , offset  )

Parameters

lob_loc
An input or output argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to be erased.
amount
An input or output argument of type INTEGER that specifies the number of bytes or characters to be erased.
offset
An optional input argument of type INTEGER that specifies the position in the large object where erasing is to begin. The first byte or character is at position 1. The default is 1.