SAP Knowledge Base Article - Preview

2515706 - SQLCODE -1009141 when executing sp_iqtablesize for a remote table

Symptom

The procedure sp_iqtablesize returns the following error when specifying a remote table:

sp_iqtablesize "DBA.tb02r"

=====

Table 'tb02r' cannot be found in the IQ store.
-- (db_iqutility.cxx yyyyy)
SQLCODE=-1009141 ODBC 3 State="HY000"

======

We can see the following message in the iqmsgs file:

====

Exception Thrown from dblib/db_iqutility.cxx:yyyy, Err# 134, tid 3 origtid 3
O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1009141, SQLState: 'QCA51', Severity: 14

======


Read more...

Environment

  • SAP IQ all versions

Product

SAP Sybase IQ all versions

Keywords

SQLCode: -1009141 ErrID: 4098 SQLState: 'QCA51' "HY000" remote table existing proxy sp_iqtablesize cannot be found IQ store , 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 for Me (Login required).

Search for additional results

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