Error 889

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

Item Description

SQLCode

-889L

Constant

NONDETERMINISTIC_FUNCTION

SQLState

42W79

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2551

Severity Code

15

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com