15.00 - 9249 The altering of RANGE_N definition with CURRENT_DATE/CURRENT_TIMESTAMP is not allowed. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

9249 The altering of RANGE_N definition with CURRENT_DATE/CURRENT_TIMESTAMP is not allowed.

Explanation:

On a table that has PPI defined using CURRENT_DATE or CURRENT_TIMESTAMP, only ALTER TABLE <tablename> TO CURRENT can be submitted to alter the PPI definition using a new date or timestamp. ALTER TABLE with ADD or DROP RANGE clause must not be used in this case.

Generated By:

OPD modules

For Whom:

End user

Remedy:

Use ALTER TABLE <tablename> TO CURRENT.