SQL Codes › SQL Return Codes -1 through -999 › -563 - INVALID ORDER: <aaa>---USE 'ASC' OR 'DESC'

-563 - INVALID ORDER: <aaa>---USE 'ASC' OR 'DESC'

Explanation

An invalid direction has been specified in an ORDER BY clause or CREATE INDEX column list.

The SQLSTATE that equates to this SQL return code is 42S11.

User Response

Use either ASC or DESC.