Use truncate lob to truncate the LOB data referenced by a LOB locator. See the Adaptive Server Enterprise Reference Manual: Commands.
