Page History
...
| Method | Description |
|---|---|
| Add | Add a new TableRangePartition object. PARAMETERS: Name (String), StartValue (String), EndValue (String). |
| AddColumnToDistributionKey | (IBM DB2 UDB 9.x only) Use to add another column to the distribution key. PARAMETERS: Name (String). |
| AddColumnToPartitionKey | Use to add another column to the partition key. PARAMETERS: Name (String). |
| AddRange | Automatically generate a range of table partitions. PARAMETERS: StartValue (String), StartValueInclusive (Boolean), EndValue (String), EndValueInclusive (Boolean), RangeWidth (Number), DurationLabel (String), Tablespace (String), Long Tablespace (String). |
| DeleteColumnFromDistributionKey | (IBM DB2 UDB 9.x only) Use to delete a column from the distribution key. Cannot delete last column in key. PARAMETERS: Name (String). |
| DeleteColumnFromPartitionKey | Use to delete a column from the partition key. Cannot delete last column in key. PARAMETERS: Name (String). |
| DeleteDistributionKey | (IBM DB2 UDB 9.x only) Use this method to delete all columns in the distribution key. This also deletes all distributions key. |
| DeletePartitionKey | Use this method to delete all columns in the partition key. This also deletes all partitions key. |
| GetDistributionColumnNumber | (IBM DB2 UDB 9.x only) Looks for the column in the distribution key. If it finds it, it returns the column's number. PARAMETERS: Name of the distribution column (String). RETURN DATATYPE: Integer. |
| GetNullsOrderForPartitionColumn | Looks for the column in the partition key. If it finds it, it returns the column's Nulls Order. PARAMETERS: Name of the partition column (String). RETURN DATATYPE: String. |
| GetPartitionColumnNumber | Looks for the column in the partition key. If it finds it, it returns the column's number. PARAMETERS: Name of the partition column (String). RETURN DATATYPE: Integer. |
| Remove | Remove a TableRangePartition specified by the given Number. PARAMETERS: Number (Integer). |
| RemoveByName | Remove the TableRangePartition specified by the given Name. PARAMETERS: Name (String). |
| SetDistributionColumnNumber | (IBM DB2 UDB 9.x only) Use to change the sequence of the columns in the partition key by setting the number of a column. PARAMETERS: Name of the partition column (String), Number (Integer). |
| SetNullsOrderForPartitionColumn | Use to set the Nulls Order for the given column if the column is found in the partition key. PARAMETERS: Name of the partition column (String), Nulls Order (String). |
| SetPartitionColumnNumber | Use to change the sequence of the columns in the partition key by setting the number of a column. PARAMETERS: Name of the partition column (String), Number (Integer). |
...