Hexadecimal to Char

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
anilkona
Participant
Posts: 50
Joined: Mon Nov 15, 2004 6:18 pm

Hexadecimal to Char

Post by anilkona »

I am trying to convert Hexadecimal value to Char.

The Hexadecimal value for example is in the format '4040404040404040F1F0F1F9' which is equivalent to ' 1019'.

I tried using OConv with codes "MCXD", "MCX".

Any ideas?

Thanks,
-Anil
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Umm... that's not hex, that's EBCDIC.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

If that's EBCDIC you need the ASCII() function, and not to have NLS enabled.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”