Log warnings

[iwin]

Hey,
I am trying to pull data from mainframes to a dataset. I have source then transformer and a dataset in the job design. when i run the job i get the following warnings.

Code: Select all

Transformer_22,2: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record dropped.

Please let me know if anyone has come across similar messages in the log.

[rleishman]

Sounds like you are reading a Packed Decimal, which - from memory - uses the first nybble to designate the sign.

What datatype have you specified in the DataStage source stage? Have you retained that datatype all the way through the other stages? Have you used the correct conversion function to convert to a regular numeric datatype?

[ray.wurlod]

Did you bother to Search the forum?