Try OpenEdge Now
skip to main content
Basic Database Tools
Admin Menu Reference : Load Data and Definitions option : Data Definitions (.df file) option

Data Definitions (.df file) option

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.
Note: The .df file may exceed 2GB on platforms where the ABL client supports large files.
When you choose this option, the Load Data Definitions dialog box shown in the following figure appears.
Figure 42. Load Data Definitions dialog box
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.
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.
Note: When you choose Load Data Definitions > Data Definitions from the menu bar, the Data Dictionary automatically loads all the table definitions, including any collation or translation tables. If you change the collate/translate tables, you must rebuild your indexes.