SPP4020 Warning, Statement beginning at line <line>:SQL statement returns <number> columns but INTO clause has <number> columns - 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

SPP4020 Warning, Statement beginning at line <line>:SQL statement returns <number> columns but INTO clause has <number> columns

Language:

C, COBOL, PL/I

Possible Cause:

INTO clause does not reference enough host variables to return all requested columns.

Possible Solution:

Add the appropriate host variables to the INTO clause.