-20522 INVALID SPECIFICATION OF WITHOUT OVERLAPS OR PERIOD CLAUSE. REASON CODE reason-code.
Explanation
The specification of the WITHOUT OVERLAPS clause was invalid.
- reason-code
- The reason why the specification was invalid:
- 2
- The columns of the specified period must not be specified in the constraint clause.
- 3
- WITHOUT OVERLAPS can be specified in a CREATE INDEX statement only if the index is defined as UNIQUE. It cannot be specified if the index is defined as UNIQUE WHERE NOT NULL.
- 5
- The columns of the specified period must not be specified in the index specification.
- 7
- WITHOUT OVERLAPS cannot be specified for an index that is defined with PARTITION BY RANGE.
- 8
- A key expression that is not a simple column reference must not be specified for the key or index when WITHOUT OVERLAPS is also specified.
System action
The statement cannot be processed.
User response
Correct the syntax, and resubmit the statement.
SQLSTATE
428HW
