DSXchange

In Server Jobs we used the OCONV function to format a VarChar length into a binary number.

Is there a function in DataStage to format a Number into a Binary Number inside a parallel transformer? How would you code a VarChar field with a length of 500?

Welcome aboard.

There are explicit conversion functions in parallel jobs, such as StringToDecimal() or StringToFloat(). I doubt that any of these has the ability to handle a 500-digit number without loss of precision, however.

Would creating an additional two character fields to hold the length of the field work and then find the length of the field and populate the length field by converting the length to hex?