RESTRUCTURE Utility Statement

Modifying Non-SQL Defined Databases › Changes to Schemas and Subschemas › RESTRUCTURE Utility Statement

RESTRUCTURE Utility Statement

What RESTRUCTURE Does

The RESTRUCTURE utility statement modifies record occurrences to fit new schema specifications. You run RESTRUCTURE in local mode using a subschema associated with a schema that describes the database before restructuring.

RESTRUCTURE does not require that the database be unloaded and reloaded. Database keys remain unchanged. New database procedures can be executed during restructuring. For example, IDMSCOMP can be executed to compress previously uncompressed records.

Steps for RESTRUCTURE

To make changes using RESTRUCTURE, follow the procedure described in the section “Procedure for Modifying the Non-SQL Definitions”, except add the steps listed in the following table.

After ...	Do this
Modifying the schema and subschemas	Execute the schema compare utility (IDMSRSTC) to generate IDMSRSTT macro statements for use in the database restructure
Executing IDMSRSTC	Assemble the IDMSRSTT statements into a base restructuring table and use the table with the RESTRUCTURE utility statement; use a subschema that describes the database before restructuring
Executing RESTRUCTURE	Connect any new pointers to existing sets using the RESTRUCTURE CONNECT utility statement; use a subschema that describes the database after restructuring
Executing RESTRUCTURE CONNECT	Write a program to connect pointers in new sets to existing records

Note: For more information about IDMSRSTC, RESTRUCTURE, and RESTRUCTURE CONNECT, see the Utilities Guide.