June 13, 2007 Bruce Guetzkow
Note: The code accompanying this article is available for download here, and it has been updated since it originally ran [Updated 06/13/07]
I have seen requests many times in the forums from programmers asking how best to handle data with invalid decimal data. Typically this type of error is first discovered when a program ends abnormally. I have found this problem occurs most often with data received from outside sources: customers and vendors. Many times this data comes from systems other than a System i. I’ve developed a command to identify and (optionally) “fix” errant data.
What’s in a