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 queriesYou run basic text search queries with the bts_contains() search predicate.
Basic Text Search query term modifiers
Proximity searchesYou can specify the number of nonsearch words that can occur between search terms in a proximity search.

Proximity searches

You can specify the number of nonsearch words that can occur between search terms in a proximity search.

To perform a proximity search, enclose the search terms within double quotation marks and append a tilde (~) followed by the number of nonsearch words allowed. For example, to search for the terms curb and lake within 8 words of each other within a document, use the following search predicate:

bts_contains(column, ' "curb lake"~8 ')