Dear all,
I have many customers who are getting below error when they are using with or with recursive clause.
[Error]
Unable to execute the statement.
Remote server does not have the ability to support this statement.
SQLCODE=-706, ODBC=3, STATE="HY000" Row 30, Column 1
IQ does not support with/with recursive clause so far.
WITH clause is introduced in SQL Anywhere documentation only.
http://infocenter.sybase.com/help/topic/com.sybase.help.sqlanywhere.11.0.1/dbreference_en11/select-s...
...
SELECT statement
Use this statement to retrieve information from the database.
Syntax
[ WITH temporary-views ]
SELECT [ ALL | DISTINCT ] [ row-limitation ] select-list
[ INTO { hostvar-list | variable-list | table-name } ]
NFR(New Feature Request) is in progress as follows. But It's not included in IQ yet.
"NFR#607124 - IQ does not include ANSI SQL-99 select .. with recursive queries."
Thanks
HTH
Gi-Sung Jang
