SQL Codes › SQL Return Codes -1 through -999 › -209 - operation DISALLOWED ON object

-209 - operation DISALLOWED ON object

Explanation

The operation listed in the text of the message you received is not supported for the listed object. The possible messages are as follows:

• ALTER TABLE DISALLOWED ON SINGLE PARTITIONS AND 'ANY' PARENTS
• ALTER TABLE MODIFY DISALLOWED ON PARTITIONED TABLE
• ALTER TABLE RENAME DISALLOWED ON PARTITIONED TABLE
• ALTER TABLE ADD (COLUMN) DISALLOWED ON PARTITIONED TABLE
• ALTER TABLE DROP (COLUMN) DISALLOWED ON PARTITIONED TABLE
• DROP TABLE DISALLOWED ON PARTITIONED TABLE

The SQLSTATE that equates to this SQL return code is 42S14.

User Response

For more information about table partitioning see the sections about table partitioning and the STAR MUF startup option in the CA Datacom/DB Database and System Administration Guide.