Recursion is not allowed without the RECURSIVE keyword
Item
Value
SQLCODE
-938
Constant
SQLE_RECURSIVE_KEYWORD_REQUIRED
SQLSTATE
42WA0
Sybase error code
13549
ODBC 2 State
37000
ODBC 3 State
42000
Probable cause
The common table expressions for a recursive query must be defined using a WITH RECURSIVE clause.