SQL - SQLCODE's - Códigos negativos -206


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -206

   
 
  • 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.