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
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

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.