17.00 - SPP4011 Warning, Statement beginning on line <line>:Truncation may occur when column <column> is returned to host variable <name> - Teradata Tools and Utilities

Teradata Preprocessor2 (SPP Prefix) Messages

prodname
Preprocessor2 for Embedded SQL
Teradata Tools and Utilities
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1096-PP2

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.