Transformer: Numeric string expected . Use default value

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Elisabete
Participant
Posts: 17
Joined: Mon Jan 03, 2011 7:55 am
Location: Odivelas

Transformer: Numeric string expected . Use default value

Post by Elisabete »

Hello all,

I'm with this error for hours, and after a several sheach in this forum I can't find my anwser...Is there many sugestions but none is the correct to my problem... I've tried everything and it still doesn't work... The type of data it's ok for all fields I compare that twice, I can't resolve this issue... Anyone can help me on this?

Thank you,
Elisabete
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

What functions or logic are you using within the transformer that will require a numeric string? Any columns which are referenced by that logic will need the strings to contain nothing but digits and appropriate numeric-related "punctuation" (signs, decimal points, etc.). Num() is a function that distinctly does not like leading spaces or empty strings.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
Post Reply