HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

Define Relation Screen 

Use the Define Relation screen to specify common items to be used for a
join.


            

To specify a new relation 

   1.  Type the name of the Common Item and its Source Table.

       If the common item has the same name in more than one source
       table, you can, if you want, enter the one name common to both
       items (and do not specify a source table).  HP ALLBASE/BRW looks
       up all occurrences of the item in all the source tables and uses
       all of them as the relation definition.  The names of the items
       and their source tables will appear in the fields.

       If the common item has different names in its source tables, enter
       item name and source table name for all occurrences of that item.

   2.  Choose Add Relation.

To modify a relation 

   1.  Use Prev Relation or Next Relation to find the relation you want
       to modify.

   2.  Make the required changes to the relations.

   3.  Press Enter.

To delete a relation 

   1.  Use Prev Relation or Next Relation to find the relation you want
       to delete.

   2.  Choose Delete Relation.

   3.  Press Enter or choose Delete Relation again to confirm the
       deletion.

Banner Line 

The banner line displays the name of the joined table for which you are
defining this relation and the number of relations defined.  For example,
"Relation 3 of 3" means you are now defining relation number three from a
total of three that exist.

Field Descriptions 

Common Item 

The name of the item for which you are defining a relation.  Single-value
and list-of-values parameters can also be specified in a relation by
preceding the name with a question mark, for example, ?MONTH.

In Source Tables 

Required.  The name of the data set, HP ALLBASE/SQL table, file or HP
ALLBASE/BRW table in which this item resides.  This must be the same name
as specified on the Define Table screen.  This field can be blank if the
common item has the same name in each source table.


NOTE  One relation stands for one common item.  Define different
      relations if you have more than one common item.


Softkeys 

Add Relation 

Choose this to add the defined relation to the report.  You can add
multiple relations to a report.  The banner line of the screen shows how
many relations have been defined and which relation you are working with.
For instance:  Relation 1 of 1 or Relation 2 of 4.

Delete Relation 

Choose this to delete a relation from the report.

Relation Condit'n 

This takes you to the Relation Condition screen.

Project Items 

This takes you to the Project Items screen.

Prev Relation 

This shows the previous relation.

Next Relation 

This shows the next relation. 

MPE/iX 5.0 Documentation