how to convert decimal to hexadecimal

reddyamarnath · Post by **reddyamarnath** » Mon Sep 12, 2011 8:02 am

Hi,
how to convert the decimal value to Hexadecimal values in job

qt_ky · Post by **qt_ky** » Mon Sep 12, 2011 2:44 pm

Have you searched dsxchange for the answer?

viewtopic.php?t=140442&highlight=hexadecimal
viewtopic.php?t=140387&highlight=hexadecimal

arunkumarmm · Post by **arunkumarmm** » Mon Sep 12, 2011 2:57 pm

There is a function Dtx() in server jobs but I'm not sure if that is available in Parallel. Maybe you can use a BASIC transformer and call this function.

baglasumit21 · Post by **baglasumit21** » Tue Sep 13, 2011 6:52 am

If you are inserting the data in oracle table then you can use the to_char function of oracle to convert the decimal value to hex. The same can be achieved by using a user defined query in oracle stage.

Rgds,
Sumit

DSXchange

how to convert decimal to hexadecimal

how to convert decimal to hexadecimal

Re: how to convert decimal to hexadecimal