SPP3001 Error at line <line>, column <column>:Found <token> when colon for indicator variable expected - 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

SPP3001 Error at line <line>, column <column>:Found <token> when colon for indicator variable expected

Language:

C, COBOL, PL/I

Possible Cause:

A colon was missing for an indicator variable in the SQL statement.

Possible Solution:

Indicator variable references require a preceding colon in all cases. Add the colon to the variable name in the SQL request.