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
Function Expressions
Bitshift Functions Bitshift functions perform a bit shift operation on an integer or bigint value and return the shift result.

Bitshift Functions

Bitshift functions perform a bit shift operation on an integer or bigint value and return the shift result.

The bitshift functions have the following syntax.

|--+-IFX_BIT_LEFTSHIFT---+--(--operand--,--amount--)--|
   '-IFX_BIT_RIGHTSHIFT--'


Element	Description	Restrictions	Syntax
operand	Entity whose bits are to be shifted. Its type will also be function's return type.	Must be of type integer or bigint.	Expression
amount	Number of bits operand will be shifted by.	Integer value between 0 and number of bits in operand's type (or respective modulo of any other integer value).	Expression

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.