Assign DBMS Column Value Domains

A DBMS Column, once initially created does not have an assigned value domain. This essentially means that any value would be considered acceptable. To restrict the value set, a Value Domain needs to be assigned. The process to assign DBMS Column Value Domains includes:

  • Start the Operational Database Model Metabase System Module
  • Select the DBMS
  • Enter User Name and Password
  • Select the Menu Item, DBMS Columns, then the subordinate menu item Maintenance, and the subordinate menu item, DBMS Column Value Domain
  • Select a DBMS Schema
  • Select a DBMS Table
  • Within the DBMS Column Value Domain hierarchy, select the DBMS Column to which a value domain should be assigned. The currently assigned value domain will be shown at the end of the entry-line. It will most likely be "Unknown."
  • Select the Value Domain Type, Containment
  • Shown will then be all the value domains that can be assigned based on the DBMS Column's parent Attribute, and parent Data Element.
  • Select one one of the allowed value domains. If the selected value domain is already assigned to the DBMS Column's parent Column, the "Assign" button will be greyed-out.
  • If assignable, Press the Assign button

For Sales and Corporate: 1-301-249-1142

Whitemarsh Information Systems Corporation

 Bowie, Maryland 20716 USA

Copyright 1981 - 2020 Whitemarsh Information Systems Corporation
Proprietary Data, All rights Reserved