Previous Topic: Area Level LOADsNext Topic: The REORG Utility


Loading from Non-Partitioned to Partitioned Tables and Back Again

The following shows the results of loading data into a table based on whether it is partitioned or not and on the parameter settings.

Non-partitioned loading to partitioned

Non-partitioned data may be loaded into a partitioned table if the non-partitioned table has the same name as the Full Parent of the partitioned table. The partition values determine to which table the row is added.

Partitioned loading to non-partitioned

Partitioned data may be loaded back to a non-partioned table if the non-partitioned table has the same name as the Full Parent of the partitioned table.

Partitioned loading to partitioned

If match on Full Parent name and then verify range values.