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 cannot be executed Next Page

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

Item

Value

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.