SAP Knowledge Base Article - Preview

2368512 - How to determine user tables in SYSTEM dbspace in IQ, a table is VIEW, find VIEW definition and other table details.


If two tables behave somewhat different in IQ, it is useful to find out if maybe one of them was created in SYSTEM dbspace and being served by SQLAnywhere engine.
Also, some difference in behavior maybe seen if one is a BASE table and another one is VIEW.



IQ any.


SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


SYSTEM, catalog store, different behavior, different answer, wrong answer, inconsistent. , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

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

Search for additional results

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