3309587 - Select view with the "WITH" clause fires "Remote server does not have the ability to support this statement" -SAP IQ

• Create a view with the "WITH" clause and a "group by" in the select, fires no error. See below.
• The error "Remote server does not have the ability to support this statement" is fired only when running a select on this view.

create view myview as with "ABC" as(
select cast(salary as integer) as "SAL" from employees as "EMP" group by SAL) select * from "ABC";
/* No error */

select * from myview;

/* Error
Could not execute statement.
Remote server does not have the ability to support this statement
SQLCODE=-706, ODBC 3 State="HY000"
Line 1, column 1
*/

SAP IQ 16.1

827786 ; CR#827786 ; CR827786 , KBA , BC-SYB-IQ , Sybase IQ , Problem