NANs: Floating point error

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
pravesh_kushwaha
Participant
Posts: 19
Joined: Fri Sep 10, 2004 12:17 am
Location: India
Contact:

NANs: Floating point error

Post by pravesh_kushwaha »

Hi,
We are doing calculation(Division) on decimal fields.
We are getting the following error

APT_CombinedOperatorController(1),0: Fatal Error: APT_Decimal::assignFromDFloat: src (NaNS) is not a usable floating point value

The precision for both the fields is 18,4.
Please suggest the solution for this error.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's complaining about your data, not about your metadata.
Check your data (perhaps using ProfileStage or AuditStage) to determine whether there are any values that do not fit the metadata definition, for example out of range, non-numeric, and so on.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

Trust Ray on this. Sure you could hack together a solution using EE, but I really really really advise that you don't. Stick to ProfileStage or AuditStage. You can build something in minutes that would take a couple hours or more under EE.
Post Reply