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.
SAP Knowledge Base Article - Preview