Hitachi

Hitachi Advanced Database Messages


KFAA30206-E

aa....aa is specified as the table name in the "bb....bb" statement. (M+J+O)

An SQL statement contains an error similar to the following: <SQLSTATE:42I01>

  • A viewed table is specified in the ALTER TABLE statement.

  • A base table is specified in the ALTER VIEW statement.

  • A viewed table is specified in the CREATE INDEX statement.

  • A viewed table is specified in the DROP TABLE statement.

  • A base table is specified in the DROP VIEW statement.

aa....aa: Type of table
  • A base table: A base table

  • A viewed table: A viewed table

bb....bb: The erroneous SQL statement
  • ALTER TABLE: Changes a table definition

  • ALTER VIEW: Re-creates a viewed table

  • CREATE INDEX: Defines an index

  • DROP TABLE: Deletes a base table

  • DROP VIEW: Deletes a viewed table

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.