Error 1000157

Message text

Columns for the index must be in ascending order. %1

Item

Value

SQLCode

-1000157L

Constant

EMSG_ASCENDING_SORT_ORDER_ONLY

SQLState

QDB57

ODBC State

ERROR

Parameter 1

location of the exception

Probable cause

The keyword DESC was used in the CREATE INDEX statement. Sybase IQ permits ascending indexes only.