unld_func statement (specification of constructor parameter reverse creation 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 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. The table below shows the argument data types.

Table 10-9 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

10.3.7 unld_func statement (specification of constructor parameter reverse creation function)

(1) Format

(2) Explanation

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

(b) func=function-name (argument-type[,argument-type...])