THE STATEMENT IS INVALID BECAUSE THE VIEW OR TABLE DEFINITION DOES NOT INCLUDE A UNIQUE NAME FOR EACH COLUMN

Conclusão: You must specify a list of column names if the result table of the subselect that is specified in the CREATE VIEW or DECLARE GLOBAL TEMPORARY TABLE statement has duplicate column names or an unnamed column (a column from a constant, function, or expression).

Ação do sistema: The statement cannot be executed. The specified view was not created, or the declared temporary table was not declared.

Resposta ao Desenvolvedor: Correct the statement by providing a list of names for the columns of the view. Refer to Chapter 5 of DB2 SQL Reference for information about the syntax of the CREATE VIEW statement or the DECLARE GLOBAL TEMPORARY TABLE statement.

SQLSTATE: 42908