Start of change

-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

End of change