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, and partial width loads and inserts are not supported for the partitioned table. The APPEND_LOAD option for loads on a partitioned table appends new rows to the end of the appropriate partition.
For more considerations, see “Loading partitioned tables”.
