Computation of Field

JezT · Post by **JezT** » Tue Jan 04, 2005 2:45 am

I am running a job that produces a three column file. One of the columns is a 10-digit Customer Number that has leading zeros if the number is not 10-digits long. This file is then transferred to another department for them to input on to their system.

They have requested that the Customer Number field by computated before being sent. Is this possible within DataStage ?

I understand that a computated number is similar to a packed decimal but unfortunately, that is about as far as my Cobol knowledge goes !

roy · Post by **roy** » Tue Jan 04, 2005 1:56 pm

Hi,
If you'll find out what you need to do in order to get the number "computed" people here might be able to help you, since I don't think anyone can with the insuficiant info you posted.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 04, 2005 3:01 pm

If all you want is leading zeroes, you can use the FMT function.

Code: Select all

Fmt(InLink.TheNumber, "R%10")

While this is not a computed field in the COBOL sense, I suspect that all your users are requiring is "computation" of the leading zeroes.
Otherwise, ask the other department to be more specific!