In this post, you’ll learn about the error message -207 the order by clause is invalid because it includes a column name but it applies to the result of a union or union all in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-207 the order by clause is invalid because it includes a column name but it applies to the result of a union or union all
Reason for the Error
The ORDER BY clause in the statement is invalid because column names are specified in the ORDER BY list, and the statement contains a subselect with the UNION or UNION ALL operator.� If an ORDER BY clause applies to the result of a UNION or UNION ALL, integers (rather than column names) must be used in the ORDER BY list to identify the columns that are to be used in ordering the result table.
Solution
Correct the statement by replacing the column names in the ORDER BY list with numeric column identifiers.
