SAP Knowledge Base Article - Preview

3009988 - What are part_xxxx tables? - SAP IQ

Symptom

Running

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?


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.0

Keywords

"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.