10.3.8 reld_func statement (specification of constructor function)

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 reld_func statement specifies a constructor function that generates values of an abstract data type during the reload operation.

Criterion
Specify the reld_func statement to reorganize a table with an abstract data type provided by a plug-in that has an unloading facility.
Rules
  1. Be sure to specify the reld_func statement if the table has an abstract data type provided by a plug-in and the plug-in has an unload facility.
  2. You can specify as many reld_func statements as there are abstract data types defined for table columns.
  3. When specifying a reld_func statement, also specify an unld_func statement as a pair.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

reld_func type=[authorization-identifier.]abstract-data-type-name,
      func=function-name (argument-type[,argument-type...])

(2) Explanation

(a) type=[authorization-identifier.]abstract-data-type-name

Specify the authorization identifier and name of the abstract data type.

Rules
  1. If the authorization identifier is omitted, the authorization identifier of the user who defined the abstract data type (normally MASTER) is assumed.
  2. 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 function. For details about the name and argument type of a constructor function, see the applicable plug-in documentation.

function-name
Specify the name of the constructor function.
argument-type
Specify the data type of the argument of the constructor function. For details about the format of the argument data type, see Section 10.3.7 unld_func statement (specification of constructor parameter reverse creation function). You cannot specify the name of an abstract data type.