DSNH207I E csectname LINE nnnn COL cc ILLEGAL ORDERBY SPECIFICATION
Explanation
If the select expression involves a UNION operator, the ORDER BY list must use numeric constants rather than variables.
System action
If the containing SQL statement is a declaration, it is discarded. If the containing SQL statement is executable, it is replaced by host language statements that will, if executed, set an error code in the SQLCA.
User response
Correct the syntax.
Severity
8 (error)