Originally posted by: SystemAdmin

Hi,

I have a map where i am typecasting a string to an integer for an attribute.

I used TEXTTOINTEGER function to do the same.

I have a question here, when I give some numeric value say 123 as input value it is getting properly converted to number as i am using the function as mentioned above. When I give abc as value in input, the value dosnt showup in my out file.

what I expected here is it should fail but type tree is passing it ahead.

Can any one explain me whats happeing here..

Thanking you in advance!!

-Thanks and Regards,Rajesekhar Potteti
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: TarunB

There's a TEXTTOINTEGER function?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: TarunB

OK I'll be more helpful.

Assuming that you're using the TEXTTONUMBER function: output rule validation will not cause the map to fail because this is not a critical error. If you turn on your output trace you will see that the conversion was attempted but "evaluated to NONE". This is not an error: it is simply a result of the operation.

If you want to force an alert in this scenario then use the ISNUMBER function with a FAIL command.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender