-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