update, delete, and insert in Partitioned Tables

The syntax to update, insert, and delete data in partitioned tables is the same as for unpartitioned tables. You cannot specify a partition in update, insert, and delete statements.

In a partitioned table, data resides on the partitions, and the table becomes a logical union of partitions. The exact partition on which a particular data row is stored is transparent to the user. SAP ASE determines which partitions are to be accessed through a combination of internal logic and the table’s partitioning strategy.

SAP ASE aborts any transaction that attempts to insert a row that does not qualify for any of the table’s partitions. In a round-robin– or hash-partitioned table, every row qualifies. In a range- or list-partitioned table, only those rows that meet the partitioning criteria qualify.

If the partition-key column for a data row is updated so that the key column value no longer satisfies the partitioning criteria for any partition, the update aborts.

Related concepts
Update Values in Partition-Key Columns