Data services - Converting a hexadecimal value to ASCII char

dataservices job design
1

Hi,

I need some help with trying to convert a hexadecimal value to ASCII character , the backend here is DB2 - please can someone help on any fucntion which can support this conversion.

Any DB2 function would also be fine.

here is the source SQL- via SQL Transform - need partner no column converted to ASCII from hexdecimal -

SELECT rtrim(o.CLIENT) as CLIENT,
rtrim(p.PARTNER_NO) as PARTNER_NO,
date(timestamp(substr(char(o.CHANGED_AT), 4, 14))) AS DATE_ACTIVITY
FROM #$DB_GL_SCHEMA#.CRMD_ORDERADM_H o

thanks for your help.

Regards,

reachmenow (BOB member since 2009-10-26)

2

Hi,

You can write custom function for converting hexadecimal to ASCII.
If you need custom function.I can write and send it to you.

Thanks,
Ram

Ram-> :india: (BOB member since 2009-03-24)

3

May be the below post can help you.

https://bobj-board.org/t/101904

Regards,
Sameer

sameer81 :new_zealand: (BOB member since 2007-09-15)

4

thanks for your help. will try this

Regards,

reachmenow (BOB member since 2009-10-26)