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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Chuck,

Yeah my preference would be to use the MI function, but I need this
quick & dirty on a production system.  So putting together an ILE RPG
program to use as an external stored procedure is out.

ILE CL might be an option, I'll have to see about REXX, not sure if I
can use it or not.

Correct me if I'm wrong, but the REXX source you provided a link too
handles a 8 byte hex string --> 4 byte integer correct?

I don't suppose you could tell me what I'd need to change to handle a
16 byte hex string --> 8 byte bug int could you? :)

Otherwise, I need to learn REXX quickly! :)

Thanks again,
Charles Wilt


On Fri, Feb 26, 2010 at 6:32 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:
>   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)?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.