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

-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.