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)

 

Recursion is not allowed without the RECURSIVE keyword

Error constant SQLE_RECURSIVE_KEYWORD_REQUIRED
ODBC 2 State 37000
ODBC 3 State 42000
Severity 16
SQLCODE –938
SQLSTATE 42WA0
Sybase error code 13549
Probable cause

The common table expressions for a recursive query must be defined using a WITH RECURSIVE clause.