Apply bitand, bitor, bitshiftleft, bitshiftright, and bitmask operations to an output window.
The example creates two schemas named IntNumbersSchema and ResultNumbersSchema.
The example applies bitwise functions to ResultNumbersSchema. Bitwise functions allow you to access and manipulate the individual bits that make up the data.
CREATE SCHEMA IntNumbersSchema ( IntNumber INTEGER ); CREATE SCHEMA ResultNumbersSchema ( IntNumber INTEGER, Bit_Shift_Left INTEGER, Bit_Shift_Right INTEGER, Bit_Mask INTEGER, Bit_And INTEGER, Bit_Or INTEGER ); CREATE Input Window InNumbers SCHEMA IntNumbersSchema Primary Key (IntNumber); CREATE OUTPUT WINDOW OutNumbers SCHEMA ResultNumbersSchema PRIMARY KEY ( IntNumber) AS SELECT i.IntNumber as IntNumber, bitshiftleft(i.IntNumber, 2) as Bit_Shift_Left, bitshiftright(i.IntNumber, 2) as Bit_Shift_Right, bitmask(0, 4) as Bit_Mask, bitand(i.IntNumber, 4) as Bit_And, bitor(i.IntNumber, 4) as Bit_Or FROM InNumbers i; ATTACH INPUT ADAPTER InAdapter TYPE dsv_in TO InNumbers PROPERTIES dir='../exampledata', file = 'Numbers1000.csv' , delimiter = '' ;