Formatting VarChar in EBCDIC for Parallel Jobs

saragaul · Post by **saragaul** » Wed Apr 30, 2008 4:45 pm

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?

ray.wurlod · Post by **ray.wurlod** » Wed Apr 30, 2008 5:09 pm

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.

saragaul · Post by **saragaul** » Thu May 01, 2008 10:05 am

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?