DSXchange

Hi,

Need to write to a flat file where first two characters of each record should be char version of a hexadecimal value. i.e. '4F44' is should show as 'OD' in output file.

Could you please suggest how to convert Hex value to Char

regards,
Satish

BASIC Transformer, Iconv(string[1,2], "MX0C")

Anyway to do it in parallel 8.1?

One can do it in PX, but not as easily. Take a look at this thread

given link says its Premium content

is there any work around?

No, no work around from me, since I believe that the site is valuable and that membership pays to keep it running.

Well, you could always flex your C++ muscles to create a more 'parallel' solution.

You can see the entirety of my entry (it's short enough not to be affected by the premium size cutoff) and it IS a parallel solution.

While my premium membership is still under review...
Found this solution in unix:

hexchar="FF"
octchar=$(echo "ibase=16;obase=8;$hexchar"|bc)
hexInChar=$(echo "\0$octchar")

Could you please suggest how to embed this code in DS job.

Via oracle char code could be found by:
select HEXTORAW(hex) as value from hextable;

Thanks for all the suggestions.

Using server job was certainly a simple and good option; however, had issues with converting values like 8A, which are not standard ascii values. DS was generating '?' where unix was generating a wierd symbol sililar to 'g'

Workaround: running the unix script after the ds job to change hex to char codes

hi

Hi ,
i must convert exadecimal values in char values in main frame job.
The function ICONV doesn't exist.
Cai i do?
Is difficult?
Bye

Marbis, please start your own post on this subject.

hi,
i convert the hexadecimal value 0D0A to charapter with the constant X'0D0A'.

Bye

Carriage return line feed?

You probably did not need to convert those explicitly at all.