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

[CRPence <CRPbottle@xxxxxxxxx>]

  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)?