In OpenEdge Release 11, the DataServer for Oracle is enhanced to enable you to define foreign RDBMS constraint definitions within the meta schema of your OpenEdge database for use in migrating your database to a foreign data source. Once migrated to the foreign data source, constraint definitions can be pulled back into your OpenEdge schema holder.

To achieve this, OpenEdge, provides a submenu for the Oracle DataServer Utilities for creating constraint definitions. The following figure shows the Server Attributes submenu.

Figure 1. Server Attributes submenu


From the Server Attributes submenu, you can access dialog boxes that provide an interface to create, view, and maintain server attributes, and define constraint definitions applied to the data and indexes of the foreign database within your OpenEdge schema holder. The dialog boxes accessed from the Server Attributes submenu are as follows:

  • View/Maintain Foreign Constraints — Use the View/Maintain Foreign ConstraintDefinitions dialog box, shown in the following figure , to define and delete constraint definitions as well as view constraint definition properties.
    Figure 2. View/Maintain Foreign Constraint Definitions dialog box


    See Defining constraint definitions in Data Administration for details on how to define constraint definitions. See Modifying an existing constraint definition for details on how to maintain constraint definitions.

  • Activate/Deactivate Constraints — Use the Activate/Deactivate Constraint Definitions dialog box, shown in the following figure , to activate or deactivate constraint definitions you defined.
    Figure 3. Activate/Deactivate Constraint Definitions dialog box


    See Activating or deactivating a class of existing constraint definitions for details on how to activate and deactivate constraint definitions.

  • Delete Constraints — Use the Delete Constraint Definitions dialog box, shown in the following figure , to delete defined constraint definitions.
    Figure 4. Delete Constraint Definitions dialog box


    See the for details on how to delete constraint definitions.