Nonstop Database, HiRDB Version 9 Command Reference

[Contents][Index][Back][Next]

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

The unld_func statement specifies a constructor parameter reverse creation function that reverses the creation of data values for abstract data type during an unload operation.

Criterion
Specify the unld_func statement to reorganize a table with an abstract data type provided by a plug-in that has an unloading facility.

Rules
  1. You can specify as many unld_func statements as there are abstract data types defined for table columns.
  2. If you are specifying the unld_func statement along with -k rorg, also specify the reld_func statement.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

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

(2) Explanation

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

Specifies 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...])

Specifies 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 manual.

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. Specify the argument's data type in the following format:
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 --