SPP4005 Error at line <line>, column <column>:<type> variable <name> does not conform to type VARCHAR or type SMALLINT - 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

SPP4005 Error at line <line>, column <column>:<type> variable <name> does not conform to type VARCHAR or type SMALLINT

Language:

C, COBOL, PL/I

Possible Cause:

The statement requires that the host variable type be either a VARCHAR or SMALLINT. Normally this error is received with the SET CHARSET statement.

Possible Solution:

Make the host variable a varying character or a small integer, depending on the information being supplied to the statement.