Ansicht
Dokumentation

SQL0214 - ORDER BY expression is not valid. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.


Message : SQL0214
ORDER BY expression is not valid.

Message Long Text :

Cause . . . . . : The expression in the ORDER BY clause in position &1 is not valid for reason code &3.
1 - The SELECT statement contains a UNION, EXCEPT, or INTERSECT.
2 - DISTINCT is specified in the SELECT clause and the expression or column cannot be matched exactly with an expression or column in the select list.
3 - The select list uses an aggregate function or there is a GROUP BY clause and the expression is not an aggregate function or does not match exactly with an expression in the select list.
4 - An aggregate function in the ORDER BY clause requires grouping.
5 - A nested table expression is not supported in an ORDER BY clause.
Recovery . . . : Make the change listed for reason &3 and try the request again:
1 - Remove the expression from the ORDER BY clause.
2 - Remove DISTINCT from the select clause or change the ORDER BY expression or column to refer to a select list item by using a numeric column identifier or a column name.
3 - Change the expression in the ORDER BY clause to an aggregate function or change to use a numeric column identifier or a column name.
4 - Add a GROUP BY clause or remove the aggregate function from the ORDER BY clause.
5 - Remove the nested table expression from the subselect in the ORDER BY clause. Consider using a common table expression instead.

Message File : QSQLMSG
Library Message File : QSYS2924


RFUMSV00 - Advance Return for Tax on Sales/Purchases   Addresses (Business Address Services)  
This documentation is copyright by IBM.

Length: 3235 Date: 20240425 Time: 180938     sap01-206 ( 2 ms )