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.