Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Bitwise Logical Functions
BITOR Function

BITOR Function

The BITOR function takes two arguments. The arguments can be any number type value that can be converted to an INT8 value.

Fractional values are truncated before the bit operation. The result is the bitwise OR of its two arguments.

If both arguments have the same integer types, the data type of the returned value is the same type as the arguments. If the arguments are of different integer types (for example, INT and INT8), the returned type is the type with the greater precision. If the arguments are any other numeric type, such as DECIMAL, SMALLFLOAT, FLOAT, or MONEY, or some combination of those types, the returned data type is DECIMAL(32)

The following example illustrates a query that calls the BITOR function:

SELECT BITOR(8, 20) AS bitor FROM systables WHERE tabid = 1;

The following table shows the output of this SELECT statement.


`bitor`
28