KFAA30758-E
The EXCLUDE NULL VALUES option cannot be specified because aa....aa. (M+J+O)
The null-value exclusion specification (EXCLUDE NULL VALUES) cannot be specified due to one of the following reasons: <SQLSTATE: 42I60>
-
The null-value exclusion specification is specified for an index that is not a B-tree index.
-
The indexed columns include a column for which the NOT NULL constraint is specified.
- aa....aa: Cause of the error
-
-
the index is not a B-tree index: The null-value exclusion specification is specified for an index that is not a B-tree index.
-
there is a NOT NULL column in the indexed columns: The indexed columns include a column for which the NOT NULL constraint is specified.
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Delete the null-value exclusion specification.