Originally posted by: Greenspan

Hello,

I have a map that reads a file with fixed length records. I need to count the record and compare for the purpose of some kind of hash validation. For that purpose i am using the function COUNTABS(type-of-the-record). This works for day to day volumes. However it did not work for a file of 100000 recods. In this case the function returns 34464 even though the occurence of the record is S and the field where the function is called is of integer and 15 digits long.
Is it some kind of limit of countabs function ? How do i resolve this ?

Many thanks
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: TarunB

I encountered this problem in 8.x some time ago. For me I noticed that the COUNTABS() function started giving incorrect results after 65535, after which it starts counting at zero again.

You can work around this by using the COUNT() function: Count all records and then subtract the count of rejected records.

We raised this to IBM and a fix is now available as far as I am aware (unfortunately I don't have the support case number). You should be able to obtain this from your IBM support contact.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Greenspan

Thank you Tarun for your reply. It seems going to IBM is our only option.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender