Numeric Overflow in Reports - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.