LLD_LobType

Home | Previous Page | Next Page Large Object Locator DataBlade Module > Functions > Smart Large Object Functions >

LLD_LobType

Returns the type of data in an lld_lob column.

Syntax

SQL

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

lob: is 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.