Format SHOW USED_BY [ qualifier ] ... element-name ,...
1 – Parameters
1.1 – element-name
Specifies the element whose children you are displaying.
2 – Qualifiers
2.1 /TYPE
Format option: /TYPE=[ ( type-name ) ] ,... Displays only children 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 name, type, and relationship type of immediate children. /BRIEF is the default qualifier.
2.3 /FULL
Displays the name, type, and relationship type of all children.
3 – Description
The SHOW USED_BY command displays the children of the element you specify. The display includes the properties of children and the values associated with these properties. The SHOW USED_BY command lists children if they have either directory or processing names. CDO looks first for the directory name and displays it if one exists. If a directory name does not exist, CDO then looks for and displays the processing name. A definition can only exist in the repository without a directory or processing name if it has a relationship to an owner that has a directory name. CDO displays a name unspecified message in this case. To display Oracle Rdb database definitions, specify the name of the database as the element-name parameter and use the /FULL qualifier. Because CDO displays the full path name of each repository element, you can use the SHOW USED_BY command to determine where each instance of a particular element occurs and how it relates to other elements.
4 – Examples
1.CDO> SHOW USED_BY EMPLOYEE_DB In this example, because no qualifier is specified, the SHOW USED_BY command displays the default information (/BRIEF). This information includes the names of immediate children of the EMPLOYEE_DB database element. 2.CDO> SHOW USED_BY /FULL FIELD_A(2) In this example, the SHOW USED_BY command with the /FULL qualifier displays all children of the FIELD_A(2) field element. 3.CDO> SHOW USED_BY /FULL /TYPE=(FIELD) EMPLOYEE_REC In this example, the SHOW USED_BY command with the /FULL and /TYPE qualifiers displays all children of EMPLOYEE_REC that are fields.