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