SPP4011 Warning, Statement beginning on line <line>:Truncation may occur when column <column> is returned to host variable <name> - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

SPP4011 Warning, Statement beginning on line <line>:Truncation may occur when column <column> is returned to host variable <name>

Language:

C, COBOL, PL/I

Possible Cause:

The receiving host variable is shorter than the column for the table/view. This pertains in particular to BYTE and CHARACTER type data.

Possible Solution:

To avoid any possible truncation, insure that the receiving field is capable of containing all possible values of the sending field.