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.

Symptom

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.


Read more...

Environment

IQ any.

Product

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

Keywords

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.