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 example code
The SQL interface
The lld_locator type

The lld_locator type

The lld_locator type defines a large object. It identifies the type of large object and points to its location. It contains three fields:

lo_protocol: Identifies the kind of large object.
lo_pointer: A pointer to a smart large object or is NULL if the large object is any kind of large object other than a smart large object.
lo_location: A pointer to the large object, if it is not a smart large object. Set to NULL if it is a smart large object.

The examples in this section show how to: