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