server to parallel function

[datastagedw]

Hello,

I have the following function in server job:

iconv(column_name,"MX")

I went through some documentation to understand that it basically converts the number from decimal to hexadecimal. is ther any equivalent function we can use in the transformer stage.However the incoming columns is char(2) and output column is numeric (12) in the server job. Please help.

Thanks

[ArndW]

PX has no equivalent to ICONV/OCONV and no corresponding hex conversion function. You can either use a BASIC transform stage or write a c++ buildop to perform the same functionality in PX.