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.