Previous Topic: -147 - OP. NOT ALLOWED AT ISOL. LEVEL UNext Topic: -149 - PLAN CAN'T SPECIFY DATACOM SQLMODE WHEN MUF OPTION SPECIFIES ANSI


-148 - SUBQUERY AT LVL aaaa NBR bbbb RETURNED MORE THAN 1 ROW

Reason:

For proper evaluation, the subquery in question must return no more than one row. The level of nesting for the subquery and the total number of levels of nesting are displayed in the message text. However, it has been determined that the subquery returned more than a single row.

The SQLSTATE that equates to this SQL return code is 21000.

Action:

Ensure that the subquery is specified in such a way as to return only one row.