The LLD_LobType function

Returns the type of data in an lld_lob column.

Syntax

SQL

CREATE FUNCTION LLD_LobType(lob LLD_Lob)
   RETURNS CHAR(4);

lob: A pointer to the smart large object

Usage

An lld_lob column can contain either binary or character data. You pass an lld_lob type to the LLD_LobType function to determine the type of data that the column contains.

Return codes

This function returns blob if the specified lld_lob contains binary data and clob if it contains character data.