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

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

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

Error constant SQLE_NONDETERMINISTIC_FUNCTION
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 The name of the non-deterministic user-defined function used in error.
Severity 15
SQLCODE –889
SQLSTATE 42W79
Sybase error code 13594
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.