Convert Hexadecimal String to Integer

[sharma]

Hi,

Can anybody please tell me how do i convert hexadecimal string to integer/bigint.
Is there any inbuilt function available for this conversion in Datastage?

[ray.wurlod]

You could use a BASIC Transformer stage and there employ the Oconv() function with "MX0C" as its second argument.

I don't believe there's an out-of-the-box function in the parallel Transformer, but there's nothing to stop you writing your own. Traverse the string from right to left multiplying each hex digit by the appropriate power of 16 and accumulate the result.