Initializing DOUBLE column to zero giving error
Moderators: chulett, rschirm, roy
Initializing DOUBLE column to zero giving error
Im Initializing some columns with 0 and there datatype is DOUBLE in a transformer. It gives me compilation error. My table has 400 colums. It is working fine if i assign column derivation to these colums. Following is the error: I dont know what im doing wrong:
<transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
<transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
more error details
<main_program> Error when checking composite operator: Output from subprocess: D:\DDPSM07\Data\DS\Dev\Projects\PPAM_DEV\RT_BP466.O\V34S0_jp9MergingPpamData_a_xfmChar0toSpac.C(319) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
(From memory) the IEEE standard that prescribes how Float and Double are stored does not permit zero (all zero bits). There is an environment variable that allows you to override this rule but I can't recall its name.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Do a derivation of
Code: Select all
StringToDecimal('0','allow_zero')