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

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.