Symptom
Running a client import results in the following errors for Virtual Tables.
SQL0204N "<SID>#DATA@XXD" is an undefined name
SQL0150N The target full select, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target. This sqlcode does not necessarily indicate a problem if the affected table is a virtual table.
Checking the developer trace files, the following errors are present along with the above errors.
Table <tabname> is a virtual table for deferred table creation.
Virtual table <tabname> needs to be converted to a table.
The CREATE TABLE statement when called to create the table fails with SQL0204N "<SID>#DATA@XXD" is an undefined name for the tablespace defined in the CREATE STATEMENT.
Read more...
Environment
Db2 LUW IBM
BC-CTS-CCO
Keywords
RSCCEXPT, exclude list , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.