-594 ATTEMPT TO CREATE A NULLABLE ROWID OR DISTINCT TYPE COLUMN column-name

Explanation

A CREATE VIEW statement attempted to create a new view with a nullable ROWID column. ROWID columns (or distinct type columns for which the source type is a ROWID) do not support null values. One of the following situations has occurred:
  • The subselect of a CREATE VIEW statement involves an outer join for which a column of the result table is a ROWID column that needs to allow for null values.

System action

The statement cannot be processed.

Programmer response

Change the content of the statement so that it does not try to create a ROWID column which must allow for null values.

SQLSTATE

42831