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

Explanation

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

SQLSTATE

42908