DB2 SQL-Error: -197
Short Description: QUALIFIED COLUMN NAMES IN ORDER BY CLAUSE NOT PERMITTED WHEN UNION OR UNION ALL SPECIFIED
A SELECT statement that specifies both the union of two or more tables and the ORDER BY clause cannot use qualified column names in the ORDER BY clause. Programmer response: Change the statement so that qualified names are not necessary in the ORDER BY clause. System action: The statement is not executed.