2.27 pddivinfgt (Acquire and output table partitioning conditions)

Organization of this section
(1) Function
(2) Executor
(3) Format
(4) Options
(5) Rules
(6) Notes
(7) Output format

(1) Function

The pddivinfgt command acquires table partitioning conditions from a data dictionary table and then outputs the information to a file.

(2) Executor

User with DBA privilege or the table owner

(3) Format

pddivinfgt -t [authorization-identifier.]table-identifier

          -f partitioning-information-file-name

(4) Options

(a) -t [authorization-identifier.]table-identifier

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 (').

(b) -f partitioning-information-file-name ~<path name> (up to 1023 bytes)

Specifies the absolute path name of the partitioning information file to which the acquired partitioning condition information is to be output.

(5) Rules

  1. The pddivinfgt command can be executed only while HiRDB is active.
  2. You can execute the pddivinfgt command on any server machine or any machine on which the HiRDB client is installed.
  3. Before you execute the pddivinfgt command, you must have specified PDHOST, PDNAMEPORT, and PDUSER in the client environment definition.
    For details about client environment definition, see the HiRDB Version 9 UAP Development Guide.
  4. The output information is not guaranteed in the following cases:
    • An error occurs while the pddivinfgt command is executing
    • The pddivinfgt command is executed at the same time that a definition SQL statement is executing
  5. If the output file name specified in the pddivinfgt command is the same as the name of an existing file, the existing file is overwritten.

(6) Notes

  1. The following are the pddivinfgt command's return codes:
    0: Normal termination
    8: Abnormal termination
  2. The table below shows the types of tables and table partitioning methods that can be obtained by the pddivinfgt command.

    Table 2-2 Types of tables and table partitioning methods that can be obtained

    Table typeTable partitioning methodWhether obtainable
    Non-partitioned table--Y
    Row-partitioned tableKey range partitioningBoundary value specificationY
    Storage condition specificationOnly equal sign (=) specified as the comparison operator for storage conditionY
    Comparison operator other than equal sign (=) specified for storage conditionN
    Hash partitioningN
    Matrix-partitioned table--N
    Legend:
    Y: Can be obtained
    N: Cannot be obtained
    --: Not applicable

  3. If you specify a table for which a linefeed code or a double quotation mark (") is specified as the partitioning key, the file output results are not guaranteed.

(7) Output format

#OwnerName : "aa...a", TableName : "bb...b"
#DivisionNumber : cc...c
dd, "ee...e", ff...f
       :
       :

Explanation
aa...a:
Authorization identifier specified in the -t option (up to 30 bytes)
bb...b:
Table identifier specified in the -t option (up to 30 bytes)
cc...c:
Number of table partitions acquired (up to 5 bytes)
For a non-partitioned table, 1 is displayed.
dd:
Partitioning condition code (=, ^=, <, <=, >, or >= is displayed)
For a non-partitioned table or if blank, -- is displayed.
ee...e:
Partitioning condition value (up to 513 bytes)
The following table shows output examples of the partitioning condition value:
Table typeValue 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 keyOutput example of "ee...e"Remarks
Non-partitioned table------NULLNot enclosed in "".
Partitioned tableNULL 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 data1000Not enclosed in "".
Spaces are deleted.
Non-numeric data"ABCD"Enclosed in "".
Legend:
--: Not applicable
#
Column value in the data dictionary table. For details, see Data dictionary table details in the HiRDB Version 9 UAP Development Guide.

If the value is NULL or for a non-partitioned table, NULL is displayed.
If the data type of the partitioning condition value is numeric data or NULL, the value is not enclosed in double quotation marks (""). Also, when the data type of the partitioning condition value is numeric data, the value is displayed with all spaces deleted.
ff...f:
Name of the back-end server that stores data corresponding to the partitioning condition (up to 8 bytes).
The name is displayed with all spaces deleted.