Re: Convert hex string to integer (bigint) in SQL..

Although the function _could_ be written in SQL, as in the example found at the noted link, I would expect using an external function might be a better option where both a portable function is not required and the amount of work performed per invocation is best reduced [as compared to the HexToInt SQL UDF for which I suspect its implementation is probably not very efficient as compared to using the MI instruction].
http://groups.google.com/group/comp.sys.ibm.as400.misc/browse_thread/thread/d2312748add3faf3/ca949144a21d9e6b

Regards, Chuck

Charles Wilt wrote:

I ran across this: http://www.ibm.com/developerworks/data/library/samples/db2/0205udfs/index.html#download

Includes a HexToInt()

On Fri, Feb 26, 2010 at 10:45 AM, Charles Wilt wrote:

Yeah, that's certain an option. I know there's a MI function that does the conversion.

Was hoping I was missing something that already existed.

Charles

On Fri, Feb 26, 2010 at 10:14 AM, sjl wrote:

I'm not sure about doing it with SQL, but I wrote an RPGIV program a few years ago that takes a hex string and computes the number from it.

It would be easy enough to build a UDF to do what you want...


Charles wrote:

SQL offers the HEX() function to convert a value to a
hexadecimal string representation.

Is there a function that goes the other way, takes the
hexadecimal string representation back to an integer (or
bigint)?