SAP Knowledge Base Article - Preview

3349018 - Compilation error encountered prevents subsequent operations when view and reference table names are the same - SAP IQ

Symptom

When a view is modified to refer to a non-existing table name that is the same as the view name, the view cannot avoid errors.

Table "UserA"."tableA" does not exist.

(dba)> create or replace view "UserB"."tableA" as select * from "UserA"."tableA";
Could not execute statement.
  Table 'tableA' not found
  SQLCODE=-141, ODBC 3 State="42S02"


This view can no longer be selected or dropped.
alter view disable also fails.

(dba)> select * from "UserB"."tableA"
Could not execute statement.
  Table 'tableA' not found
  SQLCODE=-141, ODBC 3 State="42S02"

(dba)> drop view "UserB"."tableA"
Could not execute statement.
  Table 'tableA' not found
  SQLCODE=-141, ODBC 3 State="42S02"


Read more...

Environment

  • SAP IQ 16.1

Keywords

IQ, view, select, "create or replace view", "not found", "42S02", "SQLCODE=-141" , KBA , BC-SYB-IQ , Sybase IQ , 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.