A 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 Column Value Domains includes:

  • Start the Implemented Database Model Metabase System Module
  • Select the DBMS
  • Enter User Name and Password
  • Select the Menu Item, Columns, then the subordinate menu item Maintenance, and the subordinate menu item, Column Value Domain
  • Select a Schema
  • Select a Table
  • Within the Column Value Domain hierarchy, select the 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 Column’s parent Attribute, Data Element, Dataa Element Concept, and its parent Conceptual Value Domain.
  • Select one one of the allowed value domains. If the selected value domain is already assigned to the Column’s parent Attribute, 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

2008 Althea Lane Bowie, Maryland 20716 USA

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