KFAA31651-E
A aa....aa index cannot be defined because multiple indexed columns are specified. (M+J+O)
An index cannot be defined because multiple indexed columns are specified. <SQLSTATE: 42IA7>
- aa....aa: Index type
-
-
range: Range index
-
text: Text index
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
-
A range index and text index cannot be changed to a multiple-column index. Change the database design (the specification for the indexed columns).
-
If you want to define range indexes for all indexed columns specified in CREATE INDEX statements, execute multiple CREATE INDEX statements specifying columns one at a time rather than specifying multiple columns with a single CREATE INDEX statement.
-