Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Gisung
Advisor
Advisor
0 Kudos

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

3 Comments