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.
Hierarchical data typeThe node data type helps to resolve a difficult relational database problem–transitive closure.
Node data type functionsUse these functions in queries involving the node data type.
Depth() function

Depth() function

The Depth( ) function returns the number of levels in the specified node.

Returns: integer

Syntax

Depth(node)

Example 1

EXECUTE FUNCTION DEPTH('1.22.3');

Returns: 3

Example 2

EXECUTE FUNCTION DEPTH('6.5.4.3.2.1');

Returns: 6