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

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.