division

fleurlisalu · Post by **fleurlisalu** » Wed Aug 08, 2007 4:04 am

hi!! I would like that : decimal(10.2)/integer but I have errors at the compilation, I have to test AsFloat (A) /AsFloat (B) and DecimalToDFloat(A)/AsFloat (B) but that does not go, which must I do?
Thanks in advance for your help

Dev_India · Post by **Dev_India** » Wed Aug 08, 2007 4:08 am

What is there desired output and what is the data type of the mapped column??

Maveric · Post by **Maveric** » Wed Aug 08, 2007 5:25 am

Guess decimal/decimal would work. Also depends on what your target data type is. No better way than trial and error in a smaller job to find out.

fleurlisalu · Post by **fleurlisalu** » Wed Aug 08, 2007 6:28 am

Dev_India wrote:What is there desired output and what is the data type of the mapped column??

In output i would like a decimal(10,2)
decimal(10,2)/integer = decimal(10,2) but it's bad the error is :

##W TFCP 000000 14:26:39(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W TFCP 000025 14:26:39(003) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 14:26:39(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".

ray.wurlod · Post by **ray.wurlod** » Wed Aug 08, 2007 2:40 pm

The latter two are just warnings - alerts, if you prefer.
The first is coming from a composite operator - you need to prevent operator combination to determine which stage is actually generating it.

fleurlisalu · Post by **fleurlisalu** » Thu Aug 09, 2007 2:02 am

ray.wurlod wrote:The latter two are just warnings - alerts, if you prefer.
The first is coming from a composite operator - you need to prevent operator combination to determine which stage is actually generating it. ...

i don't know if it's a warning but i can't compil my job and so I don't execute it, i don't know what i must do

ray.wurlod · Post by **ray.wurlod** » Thu Aug 09, 2007 5:15 am

This message (about Data Sets) sometimes happens when the compiler is not properly installed or licensed, or the licensing on the compiler has expired. Can you please check whether either of these situations obtains?