Home
Extending Informix®Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix® includes many built-in extensions that are fully integrated in the database server. Informix® 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 Informix®.
Informix® extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Database Extensions User's GuideThe Informix® Database Extensions User's Guide explains how to use the database extensions that come with HCL Informix®: Large Object Locator, MQ messaging, binary data types, basic text search, node data type, 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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.