What is the meaning of the SQL Code -811
-
Multiple Rows
-
Single Row
-
No Rows
-
Null Value
A
Correct answer
Explanation
SQLCODE -811 in DB2 indicates that a SELECT INTO statement or a subquery in a predicate returned more than one row, which is not allowed when a single row is expected. This error commonly occurs when using SELECT INTO without proper WHERE clause conditions to ensure uniqueness.