SAP Knowledge Base Article - Preview

3009988 - What are part_xxxx tables? - SAP IQ



select * from systab;

could sometimes return:

  • for the column table_name, tables named "part_xxxx", xxxx being a number
  • for the column table_type_str = PARTITION
  • for the column table_type = 7

Those part_xxxx tables cannot be queried.

select * from part_5280
Could not execute statement.
Object part_5280 not usable in current context.
(dblib/db_catalog.cxx 2068)
SQLCODE=-1000303, ODBC 3 State="HY000"
Line 1, column 1
(Continuing after error)

What are those part_xxxx tables/objects?



SAP IQ 16.1


SAP IQ 16.0


"part_%"; "part_";  "part_*"; "not usable in current context"; "SQLCODE=-1000303"; -1000303; , KBA , BC-SYB-IQ , Sybase IQ , HAN-DYT , SAP HANA Dynamic Tiering , BW-WHM-DST-ARC , Archiving , Problem

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.