-197   A QUALIFIED COLUMN NAME IS NOT ALLOWED IN THE ORDER BY CLAUSE WHEN A SET OPERATOR IS ALSO SPECIFIED

Explanation

The ORDER BY clause of a fullselect that includes a set operator, such as UNION, EXCEPT, or INTERSECT, cannot have qualified column names.

System action

The statement cannot be processed.

Programmer response

Change the statement to ensure that all column names in the ORDER BY clause are unqualified.

SQLSTATE

42877