COBOL · DB2 SQLCODE

SQLCODE -811

What does SQLCODE -811 mean in COBOL?

Multiple rows returned by a singleton SELECT. A SELECT INTO statement, which expects exactly one row, returned more than one row.

SQLCODE -811DB2 for z/OS · Db2 (embedded SQL in COBOL)

Condition

Multiple rows returned by a singleton SELECT. A SELECT INTO statement, which expects exactly one row, returned more than one row.

Fix

Check the WHERE clause for a condition that is not actually unique, or switch to a cursor-based FETCH loop if returning more than one row is a legitimate possibility.

Pending source verification. Not yet checked against official documentation.

Related db2 sqlcode