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.