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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

that sound have been big int not bug int.

Charles

On Mon, Mar 1, 2010 at 8:59 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
> 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.