-811 More than 1 row returned when only 1 allowed - 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

-811 More than 1 row returned when only 1 allowed

Possible Cause

Multiple rows have been returned as the result of a static SQL request. A static SQL request may return at most one row of data.

Possible Solution

Correct the SQL request such that at most one row is returned or use a cursor to process the request.