DB2 SQL-Error: -153

SQLState: 42908

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

You must specify a list of column names if the result table of the fullselect that is specified in the CREATE VIEW, CREATE TABLE, or DECLARE GLOBAL TEMPORARY TABLE statement has duplicate column names or an unnamed column (a column from a constant, function, or expression). System action: The statement cannot be executed. The specified view or table was not created, or the declared temporary table was not declared. Programmer response: Correct the statement by providing a list of names for the columns of the view or table. Refer to Chapter 5 of DB2 SQL Reference for information about the syntax of the CREATE VIEW statement, the CREATE TABLE statement, or the DECLARE GLOBAL TEMPORARY TABLE statement.

This is a free Service.
I
assume no warranty for misprints,
and for the correctness and
completeness of information and entries.