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 , BW-WHM-DST-ARC , Archiving , HAN-DYT , SAP HANA Dynamic Tiering , Problem

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.