Usage

Utility Programs › IDMSRSTC › Usage

Usage

Input

Input to the IDMSRSTC utility consists only of statements to control the utility processing.

Output

The IDMSRSTC utility generates:

A card-image file containing the IDMSRSTT macro statements with comments and error messages
A formatted listing that duplicates the information in the card-image file

Execution mode

You can execute the IDMSRSTC utility either in local mode or under the central version.

Note: For more information about the JCL used to execute IDMSRSTC, see the chapter for your operating system in this guide.

Specifying dictionary name and nodename

To override the default dictionary name or dictionary nodename that the IDMSRSTC utility will access, use the SYSIDMS DICTNAME and DICTNODE parameters. For a complete description of the SYSIDMS parameter file, see the CA IDMS Common Facilities Guide.

Review the IDMSRSTT macro statements

You should review the IDMSRSTT macro statements generated by IDMSRSTC before assembling them into a base restructuring table. Informational and warning messages included in the IDMSRSTC listing indicate statements that might require modification. You will also need to modify the macro statements under the following circumstances:

Circumstance	Modification
A database procedure not included in the new schema is to be executed during the run of the RESTRUCTURE utility.	Name the procedure in the NUPROCS parameter of the appropriate IDMSRSTT RECNAME statement.
A record being restructured includes one or more redefined elements in the new schema.	Delete the IDMSRSTT FIELD statements for the redefining elements. Alternatively, if only the prefix portion of the record is being restructured, and the record is fixed length and uncompressed, replace the IDMSRSTT FIELD statements for the record with a single IDMSRSTT FIELD statement that specifies ALL.
A record being restructured has a field that is being expanded by increasing the number of positions to the right of the decimal point.	Move the IDMSRSTT FIELD statement for the new byte(s) after the statement for the original field if the field is an unsigned zone. The new position in each statement should be changed to reflect the proper position in the record's new layout. Signed numeric or packed fields cannot be restructured by a single run of the RESTRUCTURE utility. To properly handle the sign nibble may require that the new bytes be placed to the left of the original field. You should run a user program to modify each affected record by multiplying the expanded field by the proper factor to realign the decimal position.

Circumstance

Modification

A database procedure not included in the new schema is to be executed during the run of the RESTRUCTURE utility.

Name the procedure in the NUPROCS parameter of the appropriate IDMSRSTT RECNAME statement.

A record being restructured includes one or more redefined elements in the new schema.

Delete the IDMSRSTT FIELD statements for the redefining elements.

Alternatively, if only the prefix portion of the record is being restructured, and the record is fixed length and uncompressed, replace the IDMSRSTT FIELD statements for the record with a single IDMSRSTT FIELD statement that specifies ALL.

A record being restructured has a field that is being expanded by increasing the number of positions to the right of the decimal point.

Move the IDMSRSTT FIELD statement for the new byte(s) after the statement for the original field if the field is an unsigned zone. The new position in each statement should be changed to reflect the proper position in the record's new layout.

Signed numeric or packed fields cannot be restructured by a single run of the RESTRUCTURE utility. To properly handle the sign nibble may require that the new bytes be placed to the left of the original field. You should run a user program to modify each affected record by multiplying the expanded field by the proper factor to realign the decimal position.

Note: For a description of the IDMSRSTT macro statements, see Appendix B, IDMSRSTT Macro Statements.

Assemble the IDMSRSTT macro statements

After reviewing and modifying the IDMSRSTT macro statements, you must assemble the statements into a base restructuring table for use by the RESTRUCTURE and RESTRUCTURE CONNECT utilities.

Multiple sets of IDMSRSTT macro statements

IDMSRSTC can generate multiple sets of IDMSRSTT macro statements; one set for each SCHEMA statement you submit. RESTRUCTURE and RESTRUCTURE CONNECT, however, can use only one base restructuring table at a time. Therefore, you must assemble separately each set of IDMSRSTT macro statements generated by IDMSRSTC.