Overview

IDMSRSTT macro statements define the changes to be made to the database during a restructure operation. The statements reflect the information in two schemas:

An old schema that describes the database before restructuring
A new schema that describes the database after restructuring

You can code the IDMSRSTT macro statements manually, or you can use the IDMSRSTC utility to generate the statements automatically. In either case, you must assemble the statements into a base restructuring table, which is then used by the RESTRUCTURE and RESTRUCTURE CONNECT utility statements.

Note:

For more information about generating the IDMSRSTT macro statementsautomatically, see IDMSRSTC.
For more information on restructuring a database, see RESTRUCTURE and RESTRUCTURE CONNECT.

Statement descriptions

You assemble a base restructuring table from the following statements:

Statement	Description
IDMSRSTT BUFSIZE	One for a base restructuring table
IDMSRSTT RECNAME	One for each record type being modified
IDMSRSTT SETPTR	For each record type being modified: One for each pointer in the record if any pointers are being changed One that specifies ALL if no pointers are being changed
IDMSRSTT FIELD	For each record type being modified: One for each field or group of contiguous fields if the record is variable length or if the record is fixed length and one or more fields are being changed One that specifies ALL if the record is fixed length and no fields are being changed
IDMSRSTT END	One for each base restructuring table
END	One for each base restructuring table

Coding considerations

Use the following conventions when reviewing, modifying, or manually coding IDMSRSTT macro statements:

Code each statement in uppercase on a separate line, beginning in column 2 or greater
Do not code past column 72 on any line
To continue a statement on another line:
- Put an X in column 72 of the line to be continued
- Begin the continuation line in column 16
Use commas as place-holders for omitted macro parameters
Begin comment lines with an asterisk (*) in column 1

You can find the values required by the macro parameters in the old and new schema definitions and in reports generated by the IDMSRPTS utility.

Note: For more information about the IDMSRPTS reports, see IDMSRPTS.