Ansicht
Dokumentation

SQL0122 - Column &1 or expression in SELECT list not valid. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.


Message : SQL0122
Column &1 or expression in SELECT list not valid.

Message Long Text :

Cause . . . . . : One of the following has occurred:
-- The statement contains column name &1 and an aggregate function in the SELECT clause and no GROUP BY clause is specified.
-- Column name &1 is specified in the SELECT clause but not in the GROUP BY clause.
-- An expression is specified in the SELECT clause but not in the GROUP BY clause.
-- A column or expression that is specified in the ORDER BY clause, but not in the SELECT clause, does not conform to the grouping rules listed above.
Recovery . . . : Do one of the following and try the request again:
-- If a GROUP BY clause is required, make certain that all columns or expressions in the SELECT list and ORDER BY clause are also in the GROUP BY clause.
-- If a GROUP BY clause is not needed, the SELECT list and ORDER BY clause should not contain aggregate functions with column names.

Message File : QSQLMSG
Library Message File : QSYS2924


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3243 Date: 20240420 Time: 100722     sap01-206 ( 7 ms )