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

Invalid procedure type '%1' Next Page

Invalid recursive query


Item

Value

Constant

SQLE_INVALID_RECURSION

ODBC 2 State

37000

ODBC 3 State

42000

Severity

16

SQLCODE

-921

SQLSTATE

42W99

Sybase error code

13563

Probable cause

A recursive query must consist of the UNION ALL of an initial query and an iteration query. The only set operation allowed in the iteration query is UNION ALL. A recursive reference to the name of the common table expression can only appear in the iteration query, and must not be in a SELECT that uses DISTINCT, ORDER BY, or an aggregate function. A recursive reference also cannot appear on the NULL-supplying side of an outer join, or in a subquery.