![]() Previous |
![]() Next |
The MAINTAIN ADD TO PARTITION statement adds previously-populated dimension or composite values to a partition of a previously-defined partition template object.
Tip: Use MAINTAIN MOVE TO PARTITION to maintain partition values when you have already populated a partitioned variable. |
Syntax
MAINTAIN partition-template ADD TO PARTITION partition valuelist
Parameters
A text expression that is the name of a previously-defined partition template object.
Specifies that values are to be added to the partition.
A text expression that is the name of a previously-defined partition in the partition template specified by partition-template.
Text literals or a TEXT or ID expression specifying the values to be added. When it is a TEXT expression, each element (line) is treated as a separate value. The values in the expression are added exactly as they are typed.
For a concat dimension, you can specify a value of the concat dimension, or the name of a component dimension and a value or position of that dimension. You can use the values of a dimension surrogate as the values of value.
Note that you cannot partition along an INTEGER
dimension.
Indicates a range of values.
Examples
For an example of adding values to a partition, see Example: Adding and Deleting Partition Values.