Ansicht
Dokumentation
SQL0811 - Result of SELECT more than one row. ( OS/400 )
rdisp/max_wprun_time - Maximum work process run time Fill RESBD Structure from EBP Component StructureThis documentation is copyright by IBM.
Message : SQL0811
Result of SELECT more than one row.
Message Long Text :
Cause . . . . . : The result table of a SELECT INTO statement, a subquery, or a subselect of a SET statement contains more than one row. The error type is &1. If the error type is 1 then a SELECT INTO statement attempted to return more than one row. If the error type is 2 then a subselect of a basic predicate has produced more than one row. Only one row is allowed.
Recovery . . . : Change the selection so that only one result row is returned and then try the request again. The DECLARE CURSOR, OPEN, and FETCH statements must be used to process more than one result row. For a subquery the IN, EXISTS, ANY or ALL predicates can be used to process more than one result row. If one row was expected, there may be data errors, such as duplicate rows, that are causing more than one row to be returned.
Message File : QSQLMSG
Library Message File : QSYS2924
General Data in Customer Master General Data in Customer Master
This documentation is copyright by IBM.
Length: 3217 Date: 20240417 Time: 214858 sap01-206 ( 3 ms )