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

Bruce,

I believe the issue with CL is that it doesn't support 8 byte integers.

While I could use a 8 byte character during the call to cvtch, not
sure if I can pass that back such that it it seen as a BIG INT results
from the UDF.

Charles

On Tue, Mar 2, 2010 at 9:11 AM, Bruce Vining <bvining@xxxxxxxxxxxxxxx> wrote:

I am most likely missing something (like the rest of this conversation lol),
but if you know how to do this in RPG why don't you just do the same thing
with ILE CL? Using MI (or in the case of cvtch an export of C run-time) is
just a CALLPRC away. The mechanics are similar to RPG and I've discussed
them in a few of my past articles.

On Tue, Mar 2, 2010 at 7:21 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

On Tue, Mar 2, 2010 at 5:30 AM, CRPence <CRPbottle@xxxxxxxxx> wrote:

  Responses inline.

Regards, Chuck

Charles Wilt wrote:

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.

  And a q&d MI program as external UDF would be better how?
Barbara gave information on making RPG utilize the 'cvtch' MI
instruction.  That could be used as a basis for an external UDF.

It's better because I don't have an RPG compiler on the production
box, getting an RPG program placed into production quickly requires
that somebody be dying.

CL (and I assume REXX ) I can create on production as they are
considered scripts and are not part of 5722WDS.

A technically....but I didn't make the rules and nobody wants to hear
what I think of them anyways!

Charles
 --
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.

--
Regards,
Bruce
www.brucevining.com
www.powercl.com
--
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.