In a COBOL program that executes a simple sql statement without using a cursor, does DB2 evaluates all the values return by the SQL before flagging the -811 error or Upon fetch of 1 and recognizing that another record was fetch right after that, it will flag the -811?
-811 THE RESULT OF AN EMBEDDED SELECT STATEMENT IS A TABLE OF MORE THAN ONE ROW, OR THE RESULT OF THE SUBQUERY OF A BASIC PREDICATE IS MORE THAN ONE ROW.
Explanation: Execution of an embedded SELECT statement has resulted in a result table containing more than one row. Alternatively, a subquery contained in a basic predicate has produced more than one value.
However I would like to know if DB2 stores or read the entire result of the sql before flagging -811 sqlcode