MVSFORUMS.com

jayram99 · Posted: Thu Jun 24, 2010 2:30 pm Post subject: Hexadecmial to Text Conversion

Hi,

We have a column in Table stores values as Hexadecimal.

The Data is as below.

PART 1 VALUES (X'1600FFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 2 VALUES (X'3200FFFFFFFFFFFFFFFFFFFFFFFFFFFF')

Is there any way to read the above hexadecimal charectors in text format or covert to text format.

Appreciate your Help.

Jayaram

papadi · Supermod Joined: 20 Oct 2009 Posts: 594 Topics: 1

x'FF' is not a valid "text" value.

kolusu · Posted: Thu Jun 24, 2010 3:48 pm Post subject:

jayram99,

Did you check the 3rd solution in this post?

http://www.mvsforums.com/helpboards/viewtopic.php?p=11074#11074

Kolusu

jayram99 · Posted: Thu Jun 24, 2010 4:29 pm Post subject:

Thanks Kolusu.

The table is having more than million records.

Can i do it using SORT utility after downloading the records from Table to a Seq File.

Regards,
Jayaram

kolusu · Posted: Thu Jun 24, 2010 5:42 pm Post subject:

jayram99,

Sort Products do NOT have any built-in functions to unhex. You need to write a program to do it. Search the application forum for cobol examples.

Kolusu