The Recreate Database Relations option will greatly reduce the time and effort required to recreate all affected system objects when changes have been made to a program or a physical file record layout. All current data is preserved, along with physical and logical structure and other file attributes. This option does not rely on cross-reference information. Current data base structure, file attributes and other information is analyzed when the option is run.

The recreate database relations option performs the following steps automatically:

• Renames the current physical file to preserve its data
• Creates the new physical file in using the current file attributes
• Creates all logical files built on the "old" physical into QTEMP
• Adds members to the newly created physical
• Adds members to the newly created logicals, preserving original DTAMBRS structure
• Copies data from "old" physical file to new file
• Deletes logical files from "old" physical file
• Deletes "old" physical
• Moves the new logicals from QTEMP to their original library(s)

Free Email Sign-Up

To get the latest operations automation and business intelligence news, sign up for Robot Direct by entering your e-mail address. We'll let you know about site updates or breaking news about twice a month!