hi
I want to convert a column from the datatype decimal(10,0) to integer without any warnings using a modify stage.
I tired to use the function "int32_from_decimal" but its returing rows with warning.
When checking operator: When binding output schema variable "APT_TRoutput0Rec0": When binding output interface field "NUMBER" to field "NUMBER": Conversion; from source type "decimal[10,0]" to result type "int32": Possible range limitation
If you are converting from decimal(10,0) to integer, its more like integer to integer, thats why its giving you a binding error.
Decimal (10,0) is nothing but a 10 digit integer with no decimal spaces. So, you can declare the field itself as integer of 10.
Let me know if that works !!!
Eventhough it is binding error, if read till the end of sentence, you will range limitation error. Because in the PX I orbserved that if have input 10 digit integer data type will not accept. You have declare as Bigint.
Not every ten digit number is an integer.
The largest (four byte (32 bit)) signed twos-complement integer is 2147483647; the largest unsigned is 4294967295.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
[quote="ray.wurlod"]Not every ten digit number is an integer.
The largest (four byte (32 bit)) signed twos-complement integer is 2147483647; the largest unsigned is 4294967295.[/quote]
yes you are right. If there is data coming wiht 3123456789, then obviously int32 will not accept.