SAP Knowledge Base Article - Preview

3428006 - Support of WITH clause in Sql Statement -SAP IQ

Symptom

  • SAP IQ Sql Statement syntax does NOT include WITH clause
  • SAP Sql Anywhere Statement syntax includes WITH clause
    [ WITH temporary-views ]
      SELECT [ ALL | DISTINCT ] [ row-limitation-option-1 ] select-list
    [ INTO { hostvar-list | variable-list | table-name } ]
    [ INTO LOCAL TEMPORARY TABLE { table-name } ]
  • Queries having WITH clause are executed in SAP IQ without error nor warning, however results may be inconsistent !
  • Need clarification about supporting WITH clause in IQ store tables


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

CR829051, CR#829051,  829051 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Product Enhancement

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.