Ansicht
Dokumentation

SQL0120 - Use of function &1 not valid. ( OS/400 )

SQL0120 - Use of function &1 not valid. ( OS/400 )

rdisp/max_wprun_time - Maximum work process run time   General Material Data  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0120
Use of function &1 not valid.

Message Long Text :

Cause . . . . . : Function &1 cannot be used where it was specified:
-- An aggregate function or user-defined function sourced on an aggregate function cannot be specified in a SET clause, in a GROUP BY clause, in a JOIN condition, as the return expression for a RETURN statement, or as an expression in a SET statement, a VALUES INTO statement, or a MERGE statement. An aggregate function or user-defined function sourced on an aggregate function is allowed in a WHERE clause only if the WHERE clause appears within a subquery of a HAVING clause.
-- The ARRAY_AGG function can only be specified in the select list of a SELECT INTO statement or in a scalar subquery on the right side of a SET statement. DISTINCT cannot be specified with ARRAY_AGG.
-- An OLAP specification cannot be used in a WHERE clause, in a VALUES clause, in a GROUP BY clause, in a HAVING clause, or in a JOIN condition. An OLAP specification cannot be used as an expression in a SET statement or VALUES INTO statement or MERGE statement, in the SET clause of an UPDATE statement, in a key definition of a CREATE INDEX statement, or as the return expression for a RETURN statement.
Recovery . . . : Remove the function. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


Vendor Master (General Section)   Addresses (Business Address Services)  
This documentation is copyright by IBM.

Length: 3217 Date: 20240329 Time: 170129     sap01-206 ( 2 ms )