HP 3000 Manuals HP 3000 Manuals
REPORT RELATIONSHIP
Reports on one or more relationships.
Syntax
REP[ORT] R[ELATIONSHIP] [entity-name1]
[,entity-name2]
[,entity-name3]
[,entity-name4]
[,entity-name5]
[,entity-name6]
;R[ELATIONSHIP-]T[YPE] = entity-type-name1
,entity-type-name2
[,entity-type-name3]
[,entity-type-name4]
[,entity-type-name5]
[,entity-type-name6]
[;R[ELATIONSHIP-]C[LASS] = relation-class-name]
[;A[TTRIBUTE-]L[IST]=([ attribute-name1=[attribute-value1]]
[,attribute-name2=[attribute-value2]]
.
.
.
[,attribute-nameN=[attribute-valueN]])]
[;C[OMMON] = [ common-entity-name1]
[,common-entity-name2]
[,common-entity-name3]
[,common-entity-name4]
[,common-entity-name5]
[,common-entity-name6]]
[;ALL ]
[;NAME[-ONLY] ]
[;L[IST] = information-list]
.
Parameters
entity-name(N) Name of the entity involved in the relationship to
be reported.
entity-type-name(N) Name of the entity type involved in the
relationship type of the reported relationship. No
selection criteria are allowed.
relation-class-name Name of the relationship class. No selection
criteria are allowed.
attribute-name(N) Attribute of the specified relationship type. No
selection criteria are allowed. For any attribute
whose name is not included here, there is no
qualification on the value of the attribute.
You cannot specify variable length attributes.
attribute-value(N) Value for the attribute of the relationship to be
reported. If you omit attribute-value(N), there is
no qualification on the value for the corresponding
attribute (as if the attribute-name was not
specified at all).
common-entity- If in a local domain, it is the name of the entity
name(N) involved in the common domain relationship linked
to the local domain relationship to be reported.
If in the common domain, it is the name of the
entity involved in the local domain relationship
linked to the common domain relationship to be
reported. Specifying COMMON without a value
requests a match to all relationships that do not
have a common link.
ALL Reports all information about the relationship that
the scope capabilities allow.
NAME-ONLY Reports only the name of the relationships.
information-list A list of the information about the relationship
that is desired. You can specify each piece of
information available in the ALL option
individually so you can tailor the information
returned. You can specify one or more of the
following items:
name Reports the name of the
relationship (the name is
always printed even if you omit
this choice).
attribute(1) Reports the value of the
specified attribute that is
linked to the relationship
type. The names are listed if
a subset of the attributes is
desired.
attribute(N)
attributes Reports the values of all
attributes linked to the
relationship type. If you
choose this option, any
specific attribute names that
have been listed are ignored.
scope-access Reports the access the current
scope has to the relationship.
common If in a local domain,
specifying common reports the
name of the relationship in the
common domain to which this
relationship is linked. If in
the common domain, specifying
common reports all
relationships in a local domain
linked to this relationship in
the common domain.
versions Lists all of the versions
having a copy of the
relationship.
scopes Lists all of the scopes having
access to the relationship.
The above information is listed
if the scope capabilities allow
the necessary access. If the
capabilities do not allow
access to some piece of
information, then that
information is skipped and
processing continues with the
next piece.
This clause with LIST = name,
attributes is the default if
you do not specify any of the
three listing options (ALL,
LIST, or NAME-ONLY).
Description
Do not specify entity-name(N) if this command is being saved (i.e., is
inside a START/SAVE pair). If specified within a START/SAVE pair, it is
ignored.
Note that you can use either nothing between commas (,,) or a ^ between
commas (,^,) as a placeholder to match any entity name in the middle of a
list.
Remember, you can use selection criteria (see "Selection Criteria" in
Chapter 3) in most fields to qualify the relationships retrieved.
Open Mode: Read-only, shared-update, or exclusive-update
Scope: DA scope or any scope with read access to the
relationship
Example
The following example produces a report on all relationships of type
image-database contains image-dataset with the image-database accounts.
All information about the relationship is reported: its common link (it
does not have one), the access the current scope has to the relationship,
the values of all the attributes for the relationship, the scopes having
access to the relationship, and the versions containing a copy of the
relationship.
>REPORT RELATIONSHIP accounts;
>>RELATIONSHIP-TYPE = image-database,image-dataset;
>>RELATIONSHIP-CLASS = contains;
>>ALL.
ACCOUNTS CUSTOMER
Common :
Scope-Access : OWNER
DATE-CREATED : 11/11/84 4:44 AM
DATE-CHANGED : 11/11/84 4:44 AM
SCOPE-OWNER : DA
SCOPE-CHANGED : DA
SENSITIVITY : PRIVATE
RELATIONSHIP-POSITION : 1000
BLOCKING-FACTOR : 100
CAPACITY : 10000
Scopes : SALES, MARKETING
Versions : V1, V2
1 Relationship(s) Retrieved
>