Format SHOW WHAT_IF [ qualifier ] ... element-name ,...
1 – Parameters
1.1 – element-name
Specifies the element you are considering changing.
2 – Qualifiers
2.1 /TYPE
Format option: /TYPE=[ ( type-name ) ] ,... Displays those owners of the type you specify that could possibly receive an invalid notice if you perform a change in location with the CHANGE command. 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 owners that receive a possibly invalid notice if you perform a change in location with the CHANGE command. /BRIEF is the default qualifier.
2.3 /FULL
Displays the name, type, and relationship type of all owners that receive a possibly invalid notice if you perform a change in location with the CHANGE command.
3 – Description
The SHOW WHAT_IF command displays the owners that are affected if the element you specify is modified by the CHANGE command. For the owners to be displayed, the relationship between owner and member must have an associated CDD$NOTICE_ACTION property value of SIGNAL. Owners with this property value generally represent an object outside the repository, such as a database. Each owner receives a possibly invalid warning if you issue the CHANGE command for the specified element. To determine the CDD$NOTICE_ACTION property value of a relationship, use the SHOW PROTOCOL command. The SHOW WHAT_IF command lists owners 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. An element can only exist in the repository without either a directory or processing name if it has a relationship to an element that has a directory name. CDO displays the name unspecified message in this case.
4 – Examples
1.CDO> SHOW WHAT_IF EMPLOYEE_DB In this example, because no qualifier is specified, the SHOW WHAT_IF command displays the default information (/BRIEF). This information includes the names of immediate owners that receive a possibly invalid notice if you issue the CHANGE command for EMPLOYEE_DB. 2.CDO> SHOW WHAT_IF /FULL FIELD_A(2) In this example, the SHOW WHAT_IF command with the /FULL qualifier displays all owners that receive a possibly invalid notice if you issue the CHANGE command for FIELD_A(2). 3.CDO> SHOW WHAT_IF /FULL /TYPE=(CDD$DATABASE) EMPLOYEE_REC In this example, the SHOW WHAT_IF command with the /FULL and /TYPE qualifiers displays all owners of the CDD$DATABASE type that receive a possibly invalid notice if you issue the CHANGE command for EMPLOYEE_REC.