When pdrbal is executed on a table with columns of abstract data type, the utility uses the plug-in's unload facility to rebalance the table. The unld_func statement specifies a constructor parameter reverse creation function that reverses the creation of data values for the abstract data type during the unload operation.
- Criterion
- Specify the unld_func statement to rebalance a table with an abstract data type provided by a plug-in that has an unloading facility.
- Rules
- Be sure to specify the unld_func statement if the table has an abstract data type provided by a plug-in and the plug-in has an unload facility.
- You can specify as many unld_func statements as there are abstract data types defined for the table columns.
- When specifying an unld_func statement, also specify a reld_func statement as a pair.
- Organization of this subsection
- (1) Format
- (2) Explanation
(a) type=[authorization-identifier.]abstract-data-type-name
Specify the authorization identifier and name of the abstract data type.
- Rules
- If the authorization identifier is omitted, the authorization identifier of the user who defined the abstract data type (normally MASTER) is assumed.
- If the authorization identifier or abstract data type name contains a lowercase letter or a space, enclose it in double quotation marks (").
(b) func=function-name (argument-type[,argument-type...])
Specify the name and argument type of the constructor parameter reverse creation function. For details about the name and argument type of a constructor parameter reverse creation function, see the applicable plug-in documentation.
- function-name
- Specify the name of the constructor parameter reverse creation function.
- argument-type
- Specify the data type of the argument of the constructor parameter reverse creation function. Table 10-5 shows the data types of the argument.
Table 10-5 Data types of argument (pdrbal)
Specification method | Remarks |
---|
integer | INT32 |
smallint | INT16 |
char nchar mchar | CHAR8 |
varchar nvarchar mvarchar | p_pdb_varchar_t |
float | DOUBLE64 |
smallflt | REAL64 |
blob | BLOB |
abstract-data-type-name | None |
binary | p_pdb_binary_t |