Modifying Schema Entities › Set Modifications › Changing Set Membership Options

Changing Set Membership Options

Types of changes

You can change a MANDATORY set to OPTIONAL and vice versa. You can also change an AUTOMATIC set to MANUAL.

What components are affected

When you change membership options, the schema set definition is affected. Subschemas and access modules that reference either owner or member record are also affected.

Steps to change membership options

To change membership options, regardless of whether data is loaded, follow the steps outlined in 33.2, "Modifications to an Unloaded Database".

Considerations

Changing membership options may impact existing application programs. Consider the following:

• If you change from AUTOMATIC to MANUAL or vice versa, programs that STORE member records may need to connect records into the set using a CONNECT statement or no longer issue such a CONNECT.
• If you change from OPTIONAL to MANDATORY, programs that DISCONNECT members from the set must be changed and programs that ERASE owner records may need to be changed.
• If you change from MANDATORY AUTOMATIC to any other option, programs that obtain the owner of the set may be affected (because a given member occurrence may not have an owner).