Bitwise functions available

[Serge Rielau]

Hi folks,

I had some fun writing the following C-UDF over the weekend:
BIT_AND(Bigint, Bigint)->Bigint,
BIT_OR(Bigint, Bigint)->Bigint,
BIT_XOR(Bigint, Bigint)->Bigint),
BIT_NOT(Bigint)->Bigint
BIT_SHIFT_LEFT(Bigint, Smallint)->Bigint
BIT_SHIFT_RIGHT(Bigint, Smallint)->Bigint,
BIT_TEST(BIGINT, SMALLINT)->SMALLINT
BIT_SET(BIGINT, SMALLINT)->BIGINT)
BIT_CLEAR(BIGINT, SMALLINT)->BIGINT
HEX2NUM(VARCHAR(16))->BIGINT
NUM2HEX(BIGINT)->VARCHAR(16)

I'll try to find an open-source home for them, in the meantime if
someone wants them please send me an email (sr*****@ca.ibm.com).
Also I'd like to know what others have written and would be willing to
open-source and what is out there for demand to be provided.

DISCLAIMER:
Neither IBM nor I provide any warranty. The UDF have been spot tested only.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Ian]

Serge Rielau wrote:

Hi folks,

I had some fun writing the following C-UDF over the weekend:
BIT_AND(Bigint, Bigint)->Bigint,
BIT_OR(Bigint, Bigint)->Bigint,
BIT_XOR(Bigint, Bigint)->Bigint),
BIT_NOT(Bigint)->Bigint
BIT_SHIFT_LEFT(Bigint, Smallint)->Bigint
BIT_SHIFT_RIGHT(Bigint, Smallint)->Bigint,
BIT_TEST(BIGINT, SMALLINT)->SMALLINT
BIT_SET(BIGINT, SMALLINT)->BIGINT)
BIT_CLEAR(BIGINT, SMALLINT)->BIGINT
HEX2NUM(VARCHAR(16))->BIGINT
NUM2HEX(BIGINT)->VARCHAR(16)

Serge,

You might want to don your asbestos suit in preparation for
the smack-down from Joe Celko re: bitwise functions. :-)

We could start a db2-udf project on Sourceforge, that might
be a good home.
Good luck,
Ian

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Serge Rielau]

I rarely tread the dungeons of SQL-92.
So I can live with Joe's wrath.

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab