Ansicht
Dokumentation

SQL0133 - Operator on correlated column in SQL function not valid. ( OS/400 )

ABAP Short Reference   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.


Message : SQL0133
Operator on correlated column in SQL function not valid.

Message Long Text :

Cause . . . . . : An aggregate function appearing in a subquery of a HAVING clause is not valid if the argument of the function is an expression that contains an operator (+, -, *, /, **, !!) or a scalar function that is applied to a correlated reference. An operation cannot be performed on a correlated reference since the computed value of the group cannot be determined in the outer (correlated) subselect without a possible value from the inner subselect.
Recovery . . . : If the operator is a scalar function, make the aggregate function the argument of the scalar function. Otherwise, remove the operator on the correlated reference or move the operator so it is not in the argument of the aggregate function. For example, specifying the expression in the form:
AVG( outertable.column1 + innertable.column2 )
is not valid, while the expression
AVG( outertable.column1 ) + innertable.column2
is valid.

Message File : QSQLMSG
Library Message File : QSYS2924


ABAP Short Reference   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3246 Date: 20240427 Time: 053708     sap01-206 ( 2 ms )