Format SHOW UNUSED [ qualifier ] ... element-name ,...
1 – Parameters
1.1 – element-name
Specifies the element whose relationships you are investigating.
2 – Qualifiers
2.1 /TYPE
Format option: /TYPE=[ ( type-name ) ] ,... endcondition> Displays only owners or members of the type you specify. This type must be the keyword RECORD or FIELD or a type name that is valid for this command. Valid types include instances of ELEMENT_TYPE or RELATIONSHIP_TYPE; they do not include instances of PROPERTY_TYPE.
2.2 /BRIEF_(default)
Displays the immediate owners and members of the element. /BRIEF is the default qualifier.
2.3 /FULL
Displays all owners and members of the element.
3 – Description
The SHOW UNUSED command determines whether an element has owners or members. The element must have a directory name. If the element does not have owners or members, the name and type of the element is displayed. If the element has owners or members, CDO sends an informational notice. If you receive an informational notice, issue the SHOW USES and SHOW USED_BY commands to identify these owners or members.
4 – Examples
1.CDO> SHOW UNUSED EMPLOYEE_DB In this example, because no qualifier is specified, the SHOW UNUSED command displays default BRIEF information. This information includes the names of immediate owners or members of the EMPLOYEE_DB database element. 2.CDO> SHOW UNUSED /FULL FIELD_A(2) In this example, the SHOW UNUSED command with the /FULL qualifier displays all owners or members of the FIELD_A(2) field element. 3.CDO> SHOW UNUSED /FULL /TYPE=(FIELD) EMPLOYEE_REC In this example, the SHOW UNUSED command with the /FULL and /TYPE qualifiers displays all owners or members of EMPLOYEE_REC that are fields.