[SAP IQ] IQ doesn’t support WITH/WITH RECURSIVE clause.

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-statement.html

…

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