Import/export of table definition information involves migration of table definition information. The table definition information remains in the export source dictionary tables after transfer. The following types of table definition information can be imported and exported:
Because only the definition information is transferred by table definition information import/export, the database reorganization utility (pdrorg) must be used in order to transfer the table data. A definition SQL can also be generated from the export file definition information.
HiRDB determines the export order automatically when importing or exporting tables for which referential constraints are defined. There is no need for the user to determine the export order on the basis of the referential relationships. Note that more memory is required when this method of having HiRDB determine the export order automatically is used. For this reason, you can use an option to specify whether the export order is to be determined automatically or by the user.