DML Operations on Partitions

You can perform DML operations including load, insert, delete, truncate, and truncate table partition for range partitioning. Update is supported except updating the partition key column.

Sybase IQ returns an error for DML operations on a read-only table or read-only table partition. Insert and load statements or insert by updatable cursor generate an error and operations roll back, if the given row does not fit into the specified range of partitions.

The START ROW ID option for load on a partitioned table is disallowed. The APPEND_LOAD option for loads on a partitioned table appends new rows to the end of the appropriate partition.

Related concepts
Considerations for Partitioned Table Loads