SPP4014 Warning, Statement beginning at line <line>:Numeric overflow may occur when column <column> is returned to variable <name> - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
ft:locale
en-US
ft:lastEdition
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

SPP4014 Warning, Statement beginning at line <line>:Numeric overflow may occur when column <column> is returned to variable <name>

Language:

C, COBOL, PL/I

Possible Cause:

The receiving host variable is not large enough to contain the numeric data being returned. Possible overflow if the value returned is too large.

Possible Solution:

Increase the size of the receiving variable unless all possible values returned will fit into the variable.