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


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 -158

   
 
  • Causa
    • THE NUMBER OF COLUMNS SPECIFIED FOR THE VIEW IS NOT THE SAME AS THE NUMBER OF COLUMNS SPECIFIED BY THE SELECT CLAUSE, OR THE NUMBER OF COLUMNS SPECIFIED IN THE CORRELATION CLAUSE IN A FROM CLAUSE IS NOT THE SAME AS THE NUMBER OF COLUMNS IN THE CORRESPONDING TABLE, VIEW, TABLE EXPRESSION, OR TABLE FUNCTION

      Here are two cases:
      • The number of column names specified for a view in a CREATE VIEW statement must equal the number of elements (column names, SQL functions, expressions, etc.) specified in the following AS SELECT clause.
      • The number of column names specified in a correlation clause must equal the number of columns in the corresponding table, view, table expression or table function.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Correct the syntax of the statement to specify a column name for each column in the corresponding object (table, view, etc.).
      Refer to Chapter 5 of DB2 SQL Reference for information about the syntax of the statement.

      SQLSTATE: 42811

© Copyright IBM Corp.