Sybase Error – Statement contains an illegal usage of the non-deterministic function ‘%1’

In this blog post, you’ll learn more about the Sybase Error Statement contains an illegal usage of the non-deterministic function ‘%1’ and the reason for receiving this error

Sybase SQL Error Message

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

Reason for this Error

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-deterministic function, that alias cannot be referred to elsewhere in the query.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, you’ll learn more about the Sybase Error Seek failed: the requested segment offset %2 is outside...
In this blog post, you’ll learn more about the Sybase Error No indicator variable provided for NULL result and the...
In this blog post, you’ll learn more about the Sybase Error %2: Memory & disk block number mismatch; buffer={%3} page={%4}....