HP 3000 Manuals HP 3000 Manuals
RELATE
Establishes a hierarchical relationship between like entities.
Syntax
[option] RELATE subcommand
REL
Use the RELATE command to establish a hierarchical relationship between
entities. The relationship must be between entities of the same type.
That is, only categories can be related to categories, files to files,
and so forth. A complete list of entities that can be related is given
below under Subcommands.
The subcommand identifies the type of entity for which a relationship is
established. For example, RELATE FILE establishes a relationship between
a file of type BASE and a file of type MAST, DETL, or AUTO.
Child entities are ordered within the parent's entry list in the order in
which they were related to the parent. This order can be changed through
the REORDER command.
Subcommands
Any of the following subcommands can be used with the RELATE command:
CATEGORY relates a category to a category
CLASS relates a class to a class
ELEMENT relates a data element to a data element
FILE relates a file to a file
GROUP relates an HP Inform group to a group
PROCEDURE relates a procedure to a procedure
Example
> RELATE ELEMENT
PARENT ELEMENT> Emp-num < Name of parent element.
CHILD ELEMENT> Emp-div < Name of child element.
CHILD ALIAS> Emp-num-id < Name by which the child
element is known in the
relationship.
GENERATE BYTE POSITION(N/Y)?> y < Calculates byte offset
so that element will
follow the last element
related to parent element
DESCRIPTION> The parent element describes the employee number <
> and the child element describes the employee <
> division number. <
> <
[[RETURN]] ends prompting
for description; another
ends command string.
> New command prompt.
Subcommand Prompts
For the prompts shown with an asterisk (*), you must enter a response
other than [[RETURN]] in order to implement the command string. Two
asterisks (**) next to a prompt indicate that this prompt and those which
follow are repeated until [[RETURN]] is pressed in response to this
prompt.
You enter: You are prompted for:
SUB-
COMMAND COMMAND PROMPT
RELATE CATEGORY * PARENT CATEGORY
** CHILD CATEGORY
DESCRIPTION
RELATE CLASS * PARENT CLASS
** CHILD CLASS
DESCRIPTION
RELATE ELEMENT * PARENT ELEMENT
** CHILD ELEMENT
CHILD ALIAS
GENERATE BYTE POSITION (N/Y)?
BYTE POSITION Issued if No or [[RETURN]] to
GENERATE BYTE POSITION.
DESCRIPTION
RELATE FILE * PARENT FILE
** CHILD FILE
CHILD ALIAS
CAPACITY Issued only if parent file is
type BASE.
BLOCKMAX Issued only if parent file is
type BASE.
DESCRIPTION
RELATE GROUP * PARENT GROUP
** CHILD GROUP
DESCRIPTION
RELATE PROCEDURE * PARENT PROCEDURE
** CHILD PROCEDURE
DESCRIPTION
Prompts
Depending on the subcommand used, one or more of the following prompts is
issued:
BLOCKMAX Enter the maximum physical block length (in words) for
the file within the database file (128 to 2048).
DEFAULT is 512.
BYTE POSITION Enter a positive integer value for the starting position
of the child data element field within the parent data
element field. First byte position is 1. DEFAULT is 1.
CAPACITY Enter an integer value for the maximum number of entries
for the file within the database file (0 to 999999999).
DEFAULT is 0.
CHILD ALIAS When the subcommand ELEMENT is used, enter the name by
which the child element is known within the child to
parent element relationship (20 characters maximum).
The child alias will be used by the DICTCDE and DICTPDE
utilities.
When the subcommand FILE is used, enter the name by
which the child file is known within the parent file (16
characters maximum). DEFAULT: If [[RETURN]] is pressed
in response to this prompt, the alias becomes the
child's file name, up to the first 16 characters.
CHILD CATEGORY Enter the name of an existing category that is the child
in the relationship (20 characters maximum).
CHILD CLASS Enter a numeric value which is the identifying number of
an existing security class not of type INFO (0 to 9999).
CHILD ELEMENT Enter the name of an existing data element that is the
child in the relationship (20 characters maximum).
CHILD FILE Enter the name of an existing file that is the child in
the relationship according to the following
restrictions:
If the parent file is type:
BASE - the child file must be one of the following
types:
MAST (IMAGE manual master data set)
AUTO (IMAGE automatic master data set)
DETL (IMAGE detail data set)
VPLS - the child file must be the following type:
FORM (VPLUS form)
CHILD GROUP Enter the name of an existing HP Inform group that is
the child in the relationship (20 characters maximum).
CHILD PROCEDURE Enter the name of an existing procedure that is the
child in the relationship (20 characters maximum).
DESCRIPTION Enter a textual description of the relationship (50
characters per description line allowed, unlimited
lines).
GENERATE BYTE This prompt generates data that will be used by the
POSITION (N/Y)? DICTPDE and DICTCDE utilities. Enter Y or Yes to
generate the byte offset for this child element so that
it will immediately follow the last child element
related to the parent element. If this element is the
first child element to be related to the parent element,
the byte position generated will be 1. DEFAULT is No.
PARENT CATEGORY Enter the name of an existing category that is the
parent in the relationship (20 characters maximum).
PARENT CLASS Enter a numeric value which is the identifying number of
an existing INFO type security class (0 to 9999).
PARENT ELEMENT Enter the name of the existing data element that is the
parent in the relationship.
PARENT FILE Enter the name of an existing file that is the parent in
the relationship. The file type must be one of the
following:
BASE (IMAGE database)
VPLS (VPLUS forms file)
PARENT GROUP Enter the name of an existing HP Inform group that is
the parent in the relationship (20 characters maximum).
Note that if the child group is to be related to the
highest group in the group tree structure, enter "$MENU"
as the parent group's name.
PARENT Enter the name of an existing procedure that is the
PROCEDURE parent in the relationship.