Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Database Extensions User's GuideThe HCL OneDB™ Database Extensions User's Guide explains how to use the database extensions that come with HCL OneDB™: Large Object Locator, MQ messaging, binary data types, basic text search, node data type, HCL OneDB™ web feature service for Geospatial Data, and SQL packages.
Large object managementThe Large Object Locator extension enables you to create a single consistent interface to large objects. It extends the concept of large objects to include data stored outside the database.
Large Object Locator functions
Smart large object functions
The LLD_LobType function

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.