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.
Binary data typesThe binary18 and binaryvar data types allow you to store binary-encoded strings, which can be indexed for quick retrieval.
Binary data type functions
Bitwise operation functions
The bit_complement() function

The bit_complement() function

The bit_complement() function performs a logical NOT, or one's complement on a single binary data type column.

Syntax

bit_complement(column)

The function changes each binary digit to its complement. Each 0 becomes a 1 and each 1 becomes a 0.

The function returns the value of the bitwise logical NOT operation.

In the following example the value of binaryvarcol1 is '00086000':

SELECT bit_complement(binaryvar_col1) FROM table WHERE x = 1
expression
------------------
FFF79FFF