Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What does Decimal number overflow (WHWARN 5267) mean ?

April 26, 2017decimal mean overflow

0

Posted

What does Decimal number overflow (WHWARN 5267) mean ?

1 Answer

0

Posted

Warehouse is informing you that the receiving field is not large enough to hold the numeric result of the right-side expression, variable, or literal. In such a case Warehouse will issue a warning, set the receiving field to 0, and continue processing. If the result is a valid one, then consider either expanding the receiving field or changing the field’s data type. There are a number of other numeric overflow-related WHWARN messages that are generated for the same reason, varying only with the data type of the receiving field. These include : Numeric overflow (WHWARN 6010) Packed decimal field overflow (WHWARN 6004) Zoned decimal field overflow (WHWARN 6007) Oracle number out of range.