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

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