Value

Attributes

This parameter has the following attributes:

Usage

The value that you specify must be the same data type as the column of the corresponding Column parameter. If you specify more than one partition, the values that you specify must be unique and in ascending order in the configuration file.

For Oracle, the value represents the partition boundary for the column. The partition contains all keys less than the limit that you specify with the Value parameter. If you specify MAXVALUE for a partition, the partition contains all remaining keys in the table, greater than or equal to the limit specified by the previous partition.

For Db2 and Db2 LUW, the value represents the upper limit of the partition. The partition contains all keys less than or equal to the limit that you specify with the Value parameter.

The product supports the TIMESTAMP WITH TIME ZONE data type. Enter a value in local time; the product converts the time value to Coordinated Universal Time (UTC) when taking the following actions:

• Generating the partition key
• Before using the data to determine the partitioning group for distribution purposes

The product supports the use of columns defined as TIMESTAMP WITH TIME ZONE as part of a partitioning key with [ObjectPartition]. Enter a value that adheres to the proper format for the column type, using the precision and time zone offset.

Ensure that the column that you specify as the partitioning key resolves to a unique value within the length determined by your target DBMS. For more information, see Partition-key-length.