SPP4010 Warning, Statement beginning on line <line>:<column> is nullable, but no host indicator variable is provided - 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

SPP4010 Warning, Statement beginning on line <line>:<column> is nullable, but no host indicator variable is provided

Language:

C, COBOL, PL/I

Possible Cause:

The column as defined for the table/view may contain a null value and the host variable receiving the field has no associated indicator variable.

Possible Solution:

If the field will never be null when returned to the program, no action is necessary. However, if the field might be null, an indicator variable should be provided to prevent an error situation from arising.