Choose this option to load table and sequence definitions. The .df file contains the definitions of tables, which can include fields and indexes, sequences, auto-connect records, collate/translate tables, and all their characteristics.

When you choose this option, the Load Data Definitions dialog box shown in the following figure appears.

The Load Data Definitions dialog box contains the following fields:

• Input File — The Data Dictionary prompts you for the filename that contains the data definitions you want to load into your current working database. The default file is the working physical database name with a .df extension.
• Stop If Errors Found — Specifies if you want to stop the load in the event a bad definition statement is encountered.
• Output Errors to File — Specifies if you prefer error messages to be output as files.
• Add New objects on-line — Specifies if you want to add database objects while online.
• Commit Even with Errors — Specifies whether or not to commit data definitions, even if doing so will create a error message.
• Output Errors to Screen — Specifies if you prefer error message outputs to your screen instead of a file.
• Load by sections — Specifies if you want to load the new format of the incremental .df file (delta.df) that contains sections for online schema-related operations. By default, the Load by sections is clear, and the online schema-related checkboxes are disabled. If you click OK when Load by sections is clear, both, the old and new formats of the.df file load. However, after you select Load by sections, the PreDeploy, Trigger, PostDeploy, and Offline checkboxes are enabled, allowing you to select which sections to load.

  Each section contains the schema-change operations specific to the schema-change phase. The Load Data Definition utility applies the changes for selected sections. If an error is encountered while loading any of the sections, the utility eliminates that particular section and loads other sections successfully.

  If you attempt to load the .df file with a missing section by selecting the checkbox to load that section, the load .df functionality fails, which may lead to unexpected results or corrupt schema.

  You must select at least one of the online schema-related checkboxes. For more information on each of the sections, see Dump incremental delta.df supporting online schema changes.

  Note: After selecting Load by sections, if you do not select at least one online schema-related checkbox and click OK, an error message is displayed.

When you are through selecting your options, choose OK. The Data Dictionary displays each item as it loads the definitions for that object. The Data Dictionary displays a status message and prompts you to continue.