convert hex to integer

acool · Post by **acool** » Fri Aug 13, 2004 8:38 am

Hi everyone,

I need to conver a hex number to an integer. Is there any built-in function in Datastage that does it? or I have to write my own funtion.

chulett · Post by **chulett** » Fri Aug 13, 2004 9:18 am

You'll need to write your own, I'm pretty sure. Check the online help for the MY conversion code. It "Converts ASCII characters to hexadecimal values on input, and vice versa on output." - see if that will work for you.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 13, 2004 9:19 am

At least two built-in functions.

DTX(n)

Iconv(n, "MX")

You can also use variants like Iconv(n, "MCD") and Iconv(n, "MCDX") - or maybe that last one's Iconv(n, "MCXD") - it's been a while since I played with them. Check out the DataStage BASIC manual or on-line help.

Enjoy!

chulett · Post by **chulett** » Fri Aug 13, 2004 9:23 am

Kind of an odd time for you to be posting Ray... airport lounge again?

ray.wurlod · Post by **ray.wurlod** » Fri Aug 13, 2004 9:26 am

Still in India, coming up to 21:00.