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

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.