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.
Boolean operatorsBoolean operators combine terms in logical combinations. You can use the operators AND, OR, and NOT, or their equivalent special characters, in the bts_contains() search predicate.
AND operatorThe AND operator matches documents where both terms exist anywhere in the text of a single document.

AND operator

The AND operator matches documents where both terms exist anywhere in the text of a single document.

You can also use two adjacent ampersands (&&) instead of AND.

If the query_default_operator index parameter is set to AND, the AND operator is assumed if you do not specify a Boolean operator between two terms.

The following search predicates search for documents that contain both the word UNIX and the phrase operating system:

bts_contains(column, ' UNIX AND "operating system"  ')

bts_contains(column, ' UNIX && "operating system"  ')

The following search predicates search XML data for documents that contain both the word travel in the book field and the word stewart in the author field:

bts_contains(column, ' book:travel AND author:stewart  ')

bts_contains(column, ' book:travel && author:stewart  ')

The following search predicate searches for documents that contain both the word travel in the book field and the phrase john stewart in the author field:

bts_contains(column, ' book:travel AND author:"john stewart" ')