Run time warning WARNING: DS0104-COBOL

roy · Post by **roy** » Wed May 18, 2011 2:34 am

Hi All,
The warning I get from the MainFrame's run logs is:

WARNING: DS0104-COBOL A numeric data assignment caused an overflow;
Some numeric precision was lost.

Any ideas on how to get to the column in question?
I got quite a few of them ...

Thanks in advance ...

ray.wurlod · Post by **ray.wurlod** » Wed May 18, 2011 4:02 am

First thing to do is to look for some columns with large numbers in them, or columns that derive from multiplication somewhere in the job design.

roy · Post by **roy** » Wed May 18, 2011 5:19 am

In other words, are you saying there is no other way except try and error; Ray? Not(

ing)

ray.wurlod · Post by **ray.wurlod** » Wed May 18, 2011 5:39 pm

No, you can inspect your logic looking for likely candidates to cause an arithmetic overflow (usually multiplication, but maybe also addition (aggregation) over many values). Also look at the source data for numeric columns that contain large values. No need to "try" the job.

roy · Post by **roy** » Sun May 22, 2011 3:30 am

It turns out that the table was built with 3 fields that were defined shorter then they really are.
Once this was found and corrected the warnings were gone

Thanks Ray!