Contents Index Statement contains an illegal usage of the non-deterministic function '%1' Statement interrupted by user

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

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


Item Value
SQLCODE -864
Constant SQLE_INVALID_NUMBER
SQLSTATE 42W71
Sybase error code 13869
ODBC 2 State 37000
ODBC 3 State 42000
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.


Contents Index Statement contains an illegal usage of the non-deterministic function '%1' Statement interrupted by user