Reading Hexadecimal Data using CFF stage

anand_dafaria · Post by **anand_dafaria** » Tue Dec 23, 2008 10:32 pm

Hi,
We are reading Binary files using CFF stage. One attribute is having Hexadecimal data in it with PIC X as its datatype in the copybook. We are able to read the entire file but the data of the above said attribute is coming as square characters when we view the data.

Is there any way that we can read the Hexadecimal data in correct form using CFF stage or any workaround to read the attribute having hexadecimal value in it??

Any help would be highly appreciated.

Thanks
Anand

ray.wurlod · Post by **ray.wurlod** » Wed Dec 24, 2008 3:39 am

Ignore what View Data is showing you. Characters 0x00 through 0x0F can be represented by PIC X. These are not printable characters. What did you expect to get?

anand_dafaria · Post by **anand_dafaria** » Thu Jan 29, 2009 12:04 am

Hi Ray,
Thanks for you reply.

The value for one field defined as PIC X; on the mainframe side it is hexadecimal value coming as below:

##########################
<blank>
<blank>
a
j
e
f
##########################

The records like a,j,e,f are getting correctly read from the mainframe side but the <bank> characters are getting converted to some square characters. But when we actually on the mainframe side after putting the HEX ON these blank characters are actually some hexadecimal values like 81,91,61 etc.

So how these values can be fetched in Datastage. Any idea would be higly appreciated.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 29, 2009 1:53 am

I'd prefer to use one of the lookup functions in a Modify stage, for example lookup_int16_from_string().