Contents Index Statement cannot be executed Statement contains an illegal usage of the NUMBER(*) function

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

Statement contains an illegal usage of the non-deterministic function '%1'


Item Value
SQLCODE -889
Constant SQLE_NONDETERMINISTIC_FUNCTION
SQLSTATE 42W79
Sybase error code 13594
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 The name of the non-deterministic user-defined function used in error.
Probable cause 

Non-deterministic functions cannot appear in a CHECK constraint, or any other type of integrity constraint. They may appear anywhere within a query, view, or derived table. However, if an aliased SELECT list expression contains a non-determinstic function, that alias cannot be referred to elsewhere in the query.


Contents Index Statement cannot be executed Statement contains an illegal usage of the NUMBER(*) function