iAnywhere.com - Statement contains an illegal usage of the NUMBER(*) function

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Statement contains an illegal usage of the NUMBER(*) function

Item	Value
Constant	SQLE_INVALID_NUMBER
ODBC 2 State	37000
ODBC 3 State	42000
Severity	15
SQLCODE	-864
SQLSTATE	42W71
Sybase error code	13869

Probable cause

The NUMBER and IDENTITY functions can only appear in the select list of the outer-most SELECT block. It cannot be used in any subquery or in a predicate.