Try OpenEdge Now
skip to main content
DataServer for Oracle
The DataServer Tutorial : Managing server attributes
 

Managing server attributes

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 10. 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 11. 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 12. Activate/Deactivate Constraint Definitions dialog box
See Activating or deactivating a class of existing constraintdefinitions 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 13. Delete Constraint Definitions dialog box
See the for details on how to delete constraint definitions.
* Overview of foreign database constraint definitions
* Constraint definition names
* Defining constraint definitions in Data Administration
* Modifying an existing constraint definition
* Activating or deactivating a class of existing constraint definitions
* Deleting an existing constraint definition