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.
Basic Text SearchYou can perform basic text searching for words and phrases in a document repository stored in a column of a table.
Basic Text Search XML index parameters
The all_xmlattrs index parameter

The all_xmlattrs index parameter

Use the all_xmlattrs parameter to search on XML attributes in a document repository stored in a column of a table. This parameter enables searches on all attributes that are contained in the XML tags or paths in a column that contains an XML document.

Specify an attribute using the syntax @attrname, where attrname is the name of the attribute.

All the XML attributes are indexed as fields in the bts index. If you use the xmlpath_processing parameter, full paths are indexed. The text value within fields can be searched. The tags of XML tags are not indexed in a field unless you use the all_xmltags index parameter.

To view the fields that you have indexed, use the bts_index_fields() function. See bts_index_fields() function.