To load definitions into a database, you use a data definition (.df) file. The .df file contains definitions for tables, fields, and indexes. Based on the contents of the .df file, you can load either all the data definitions for a table or only those that have changed.

Note: The Data Dictionary allows you to load data definition files (.df) greater than 2GB on platforms where ABL supports large files.

To load data definitions into a table:

  1. Choose Admin > Load Data and Definitions > Data Definitions (.df file). The Data Dictionary prompts you for the name of the file that contains the data definitions you want to load into your current working database.
  2. Specify a filename or accept the default. The default filename is the working physical database name with a .df extension.
  3. Specify whether you want to stop the load in the event a bad definition statement is encountered.
  4. Specify if you prefer error message to be output as files.
  5. Specify if you want to add database objects while online.
  6. Specify whether to commit data definition changes, even if doing so will create an error message.
  7. Specify if you prefer error messages output to your screen instead of a file.
  8. Choose OK.

    If the data definitions file does not specify a code page, the Data Dictionary prompts you for one.

    The Data Dictionary displays each item as it loads the definitions for that object. It then displays a status message and prompts you to continue.

    If the definition file contains encryption policies, you must be authorized to load the file.