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

Conclusão: 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.

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