Error 152

"Invalid ORDER BY specification"

Item Description

SQLCode

-152L

Constant

INVALID_ORDER

SQLState

53005

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2095

Severity Code

15

Probable cause

Either you used an integer in an ORDER BY list and the integer is larger than the number of columns in the select list, or you specified an ORDER BY expression that is semantically invalid. For example, with UNION queries you can only use integers to specify an ordering of the result.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com