SPP4003 Error at line <line>, column <column>:<type> variable <name> does not conform to a valid numeric type - 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

SPP4003 Error at line <line>, column <column>:<type> variable <name> does not conform to a valid numeric type

Language:

C, COBOL, PL/I

Possible Cause:

The host variable is required to be of a numeric type as used in the SQL statement.

Possible Solution:

Change the host variable definition to be a valid numeric type (integer, small integer or decimal with length < 10 and no decimal digits).