SPP4021 Warning, Statement beginning at line <line>:Can't check INTO clause; cursor controls more than one SQL statement - 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

SPP4021 Warning, Statement beginning at line <line>:Can't check INTO clause; cursor controls more than one SQL statement

Language:

C, COBOL, PL/I

Possible Cause:

Informational only. This is to warn that the output host variables cannot be verified since the precompiler does not know what statement of a multi-statement request is being returned at this point in the processing. Any variable mismatches will be reported at execution time.

Possible Solution:

The user should be aware of potential variable mismatches, but no action is required at precompile time.