SAP Knowledge Base Article - Preview

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

Symptom

  • 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
*/


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.