Numeric Overflow in Reports
When in Field Mode, a numeric overflow error returned for numeric or decimal data types in a report, is reported as '***' instead of 'Error.... etc.' The following query returns the correct format because the format accommodates the number of digits returned:
SELECT cast (123456 as integer format '$999,999');
The result is:
123456
$123,456
But the next query returns an overflow reported as asterisks '***...':
SELECT CAST (123456 as integer format '$99,999');
The result is:
123456
*******
If the same query is executed in Record or Indicator Mode, the numeric overflow is reported as an error, the preferred response.