15.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
Teradata Tools and Utilities
vrm_release
15.00
category
Programming Reference
featnum
B035-1096-015K

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.