The pddivinfgt command acquires table partitioning conditions from a data dictionary table and then outputs the information to a file.
User with DBA privilege or the table owner
pddivinfgt -t [authorization-identifier.]table-identifier -f partitioning-information-file-name |
Specifies the name of the table whose partitioning condition information is to be acquired. This must be a base table.
When the authorization identifier is omitted, the authorization identifier specified in the PDUSER client environment definition is assumed.
If the authorization identifier or table identifier is enclosed in double quotation marks ("), the command treats it as being case sensitive. If it is not enclosed in double quotation marks ("), the command treats it as in all upper-case letters. If the table identifier contains a space, you must enclose it in double quotation marks (").
If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose this information in single quotation marks (').
Specifies the absolute path name of the partitioning information file to which the acquired partitioning condition information is to be output.
Table 2-2 Types of tables and table partitioning methods that can be obtained
Table type | Table partitioning method | Whether obtainable | ||
---|---|---|---|---|
Non-partitioned table | -- | Y | ||
Row-partitioned table | Key range partitioning | Boundary value specification | Y | |
Storage condition specification | Only equal sign (=) specified as the comparison operator for storage condition | Y | ||
Comparison operator other than equal sign (=) specified for storage condition | N | |||
Hash partitioning | N | |||
Matrix-partitioned table | -- | N |
#OwnerName : "aa...a", TableName : "bb...b" |
Table type | Value of the DCVALUES column in the SQL_DIV_TABLE data dictionary table# | Value of the DCVALUES_TYPE column in the SQL_DIV_TABLE data dictionary table# | Data type of the partitioning key | Output example of "ee...e" | Remarks |
---|---|---|---|---|---|
Non-partitioned table | -- | -- | -- | NULL | Not enclosed in "". |
Partitioned table | NULL value | -- | -- | ||
Non-NULL value | 'X'(hexadecimal literal) | -- | X'41424344' | Enclosed in X''. A hexadecimal character string is output. | |
NULL value (other than hexadecimal literal) | Numeric data | 1000 | Not enclosed in "". Spaces are deleted. | ||
Non-numeric data | "ABCD" | Enclosed in "". |