A procedure (stored procedure) specified in CREATE TYPE cannot be migrated to another HiRDB system.
The following information is migrated:
The table definition information and the table data for the table that is used by a stored procedure are migrated to the target system; for the migration procedure, see 12.1 Migrating a table to another HiRDB system.
This procedure can be skipped if the target system already contains the table definition information and table data for the table that is used by the stored procedure.
The dictionary import/export utility (pdexp command) to used to migrate a stored procedure from the data dictionary LOB RDAREAs to the target HiRDB system. Figure 12-5 shows the procedure for migrating a stored procedure with the dictionary import/export utility.
Figure 12-5 Migration of a stored procedure with the dictionary import/export utility
Figure 12-6 provides an overview of the procedure for migrating a stored procedure.
Figure 12-6 Procedure for migrating a stored procedure