This message appears when one or more SELECT statements are connected by the UNION keyword, and a SELECT statement other than the final one contains an ORDER BY clause. Only the

last

SELECT statement in a UNION may contain an ORDER BY clause, which is used to order the UNION output table. Also note that the ORDER BY clause must reference an output column by

number

.

This message may also appear when an internal error prevents the successful execution of a SELECT statement with an ORDER BY clause. Retry the SQL command. If this error message appears again, the DBA should shut down the database instance, and then restart the instance and reestablish a connection. If this error message still appears in response to the original SQL command, contact Informatica Global Customer Support.