|
- Causa
- column-name IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE, OR IS NOT A COLUMN OF THE
TRIGGERING TABLE OF A TRIGGER.
This return code is used to report one of the following errors:
- In the case of an INSERT or UPDATE statement, the specified column is not a column of the table or view that was specified as the object of
the insert or update.
- In the case of an INSERT with VALUES clause, there is a column referenced and columns are not allowed in the VALUES clause.
- In the case of a SELECT or DELETE statement, the specified column is not a column of any of the tables or views identified in a FROM clause
in the statement.
- There is a correlated reference in the GROUP BY clause in the select list of a subselect, or a correlated reference is not used in a search
condition.
- There is an unresolved qualified reference in HAVING.
- For a CREATE TRIGGER statement:
- A reference is made to a column using an OLD or NEW correlation name.
The column name is not defined in the triggering table.
- The left side of an assignment in the SET transition-variable statement in the triggered action specifies an old transition
variable where only a new transition variable is supported or trigger was not created.
- Ação do sistema
- The statement cannot be executed. No data was retrieved, inserted, or updated or the trigger was not created.
- Resposta ao Desenvolvedor
- Verify that the column and table names are specified correctly in the SQL statement.
In the case of a SELECT statement, check to be sure that all of the required tables were named in the FROM clause.
In the case of a CREATE TRIGGER statement, ensure that only new transition variables are specified on the left side of assignments in the SET
transition-variable statement and that any reference to columns of the triggering table are qualified with a transition variable correlation name.
SQLSTATE: 42703
© Copyright IBM Corp.
|
| |