17.00 - SPP4020 Warning, Statement beginning at line <line>:SQL statement returns <number> columns but INTO clause has <number> columns - Teradata Tools and Utilities

Teradata Preprocessor2 (SPP Prefix) Messages

prodname
Preprocessor2 for Embedded SQL
Teradata Tools and Utilities
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1096-PP2

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.