IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

How to trap number precision over flow

  • 1.  How to trap number precision over flow

    Posted 05/26/11 10:19 AM

    Originally posted by: JSmailes


    Hi

    We have a map that failed with
    Mapping return code 27, severity WARNING
    Output type contains errors
    Job step return code is 4

    We have Audit switched on and audit each output record but there was no entry on the Audit log.

    Audit Track Details Item Data
    Outputrecs Error Error Error

    The error was eventualy tracked down to a field precision issue where a value of 282.23 would not fit into the destination field. The destination field was filled by WTX with ##### characters.
    We know why the precision error occured and have instigated a fix but it took a lot of finding as nothing was reported in the Audit log. I have tried to make WTX trap this and produce a Audit but have been unsuccessful.
    Does anyone have any idea on how to do this ? We currently use the Z/OS Command Server and have -AD set.

    Regards
    John
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender