Previous Topic: -183 - MUST SPECIFY DATACOM SQLMODE FOR CURSORS TO SURVIVE UNITS OF WORKNext Topic: -185 - accessor-id HAS NO action-type AUTHORITY ON object


-184 - COLUMN NAME LIST REQUIRED ON CREATE VIEW CONTAINING NON-SIMPLE COLUMN

Explanation

You have attempted to create a view using a CREATE VIEW statement where one or more of the columns consisted of an expression or a column function, but you failed to include a column name list. A column name list must be included when all view columns are not simple column references.

The SQLSTATE that equates to this SQL return code is 42908.

User Response

Either insert a column name list into the CREATE VIEW statement or alter the view-defining query to select only simple columns so that the column names can be inherited by the view.