DB2 - DataBase Abend SQL -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 VALUE.

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.

DB2 - DataBase Abend SQL +100

ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE.

Explanation:: One of the following conditions occurred:
* No row met the search conditions specified in an UPDATE or DELETE statement.
* The result of a SELECT INTO statement was an empty table.
* A FETCH statement was executed when the cursor was positioned after the last
row of the result table.
* The result of the subselect of an INSERT statement is empty. When a SELECT
statement is executed using SPUFI, this SQL code indicates normal completion.

Mainframe Abend Code and Remedy.

ABEND=U0041 :: IMS STATUS CODE: AI

GNCSYSDB.STOPPED THE DATABASE WITH THE
HELP OF OPERATIONS AND RESTARTED THE JOB.
JOB ENDED OK.