Re: Convert character hex to decimal

David,

Your "requirements" as stated are not totally clear ...   perhaps you can describe a suggested "use case"?


Is your "hex characters" input a human-readable string of hexadecimal characters, e.g. in EBCDIC, that proposed value of 'BC614E' would actually be represented in memory as x'C2C3F6F1F4C5'? 


By "decimal" do you mean "packed decimal" or "zoned decimal"?

Do you want the result as human-readable characters, or do you want the result as a binary integer?

There are MI instructions to convert from hex to character and vice versa, see:  cvthc and cvtch   You can invoke those MI instructions as "built-in" functions directly from any ILE language.

You could write a small ILE RPG IV "wrapper" to turn those into SQL callable functions.

Does that help?

Mark S. Waterbury



On Monday, September 9, 2019, 8:47:47 AM EDT, David Gibbs via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Folks:

Does anyone have a routine handy (or know of an API) that will convert
hex characters to decimal or integer?

For example: If I have the character value 'BC614E' I would get
12345678 returned.

I had hoped there would be something in SQL, since there is a HEX
function that will convert a numeric into character hex, but it
doesn't appear to exist.

Thanks!

david