8.9.11 tblname statement (re-registration of table data to another table)

The tblname statement specifies that unloaded table data is to be reloaded to another table.

Criterion
Specify the tblname statement to migrate data between different tables on the same system or different systems.
Rules
  1. You cannot specify the tblname statement in the following cases:
    • A table to be reloaded or a table unloaded without the -j option specified has LOB columns or abstract data type columns including the LOB attribute.
    • Table definitions do not match between the unloaded table and the table to be reloaded.
  2. To specify the tblname statement, you must specify at least one unload statement. You cannot specify more than one tblname statement.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

tblname {[authorization-identifier.]table-identifier|authorization-identifier}

(2) Explanation

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

Specifies the authorization identifier and table identifier of the unloaded table.

For details about how to specify [authorization-identifier.]table-identifier, see the explanation of the -t option.

Rules
  1. If the authorization identifier is omitted, the system utility assumes the authorization identifier specified in the -t option or the one used to establish connection with HiRDB. Therefore, if the unloaded table and the table to be reloaded have different authorization identifiers, be sure to specify this option.
  2. To reload to a table with an abstract data type, some plug-ins require a constructor parameter reverse creation function during the unload operation.
  3. If you specify [authorization-identifier.]table-identifier, you cannot specify [authorization-identifier.] all in the -t option.
(b) authorization-identifier

To reload table data to another table in units of schemas, this option specifies the authorization identifier.

If you are specifying this option, you must specify [authorization-identifier.]all in the -t option.