Changes a non-partitioned table into a partitioned table. If the specified table is a distributed table or already a partitioned table, an error is returned. A table with an identity column cannot be partitioned. A DDS-created physical file cannot be partitioned. See CREATE TABLE for a description of the partitioning-clause.
Changing a non-partitioned table that contains data into a partitioned table will require data movement between the data partitions. When using range partitioning, all existing data in the table must be assignable to the specified range partitions.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.