Skip to Content
Author's profile photo Gi-sung Jang

[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.


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.

SELECT statement

Use this statement to retrieve information from the database.


[ 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.”



Gi-Sung Jang

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Remi ASTIER
      Remi ASTIER


      Did you get any response on this from product management ?

      Author's profile photo Gi-sung Jang
      Gi-sung Jang
      Blog Post Author


      I don't receive any replies from product management yet.


      Gi-Sung Jang

      Author's profile photo Harpreet Chaudhary
      Harpreet Chaudhary

      As per product management 'There are no immediate plans for implementing this feature in IQ at the moment'. Please do open an incident and have your requested added onto the feature request.