Configuring Sun Master Indexes

Defining Key Fields for an Object

You can specify that a certain field or combination of fields be unique in a system object or SBR. An example of a unique fields would be the address type if only one address of each type is allowed. A field’s key type status in midm.xml must match its key type status in object.xml. If you modify a field's key type status in the object structure using the Configuration Editor, midm.xml is automatically updated as well.

ProcedureTo Modify the Key Status

  1. In the Projects window, expand the Configuration node in the project you want to modify, and then double-click midm.xml.

    The file opens in the NetBeans XML editor.

  2. Scroll to the node element that defines the object containing the field you want to modify.

  3. Scroll to the field element you want to modify.

  4. To specify that a field must be unique in a system object, change the value of the key-type element to true.

  5. To specify that a field does not need to be unique in a system object, change the value of the key-type element to false.

    For example:


    <key-type>false</key-type>
  6. To specify that a combination of fields must be unique for an object rather than just one single field, set the key-type element to true for each field.

  7. Save and close the file.