HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

Define Table Screen 

Use this screen to specify the source tables and the type of combination
to be performed to create the result table.


            


            

To add a new table 

   1.  Type the new Table, Type, Source Table, Location, and Password.
       For an open join table, also type the name of the source table for
       the open join.

   2.  Choose Add Table.

To modify a table 

   1.  Use the Next Table or Prev Table softkeys to access the table you
       want to modify.  You can also use quick browse to access a table.
       See Chapter 1  for details about the quick browse feature.

   2.  Type modifications to the table definition.

   3.  Press Enter.


NOTE  Changing source tables or open join definitions causes changes in
      other data access screens.  You should check all relation, relation
      condition, item projection and tune access specifications to ensure
      they are still correct.


To rename a table 

   1.  Use Next Table or Prev Table to access the table you want to
       rename.  You can also use quick browse to access a table.  See
       Chapter 1  for details about the quick browse feature.

   2.  Change the name in the Table field.

   3.  Press Enter.

   4.  Press Enter again to confirm the rename.

To delete a table 

   1.  Use Next Table or Prev Table to access the table you want to
       delete.  You can also use quick browse to access a table.  See
       Chapter 1  for details about the quick browse feature.

   2.  Choose Delete Table.

   3.  Press Enter or choose Delete Table to confirm the deletion.

To copy a table 

   1.  Type the name of the new table and press Clear Display.

   2.  Choose Add Table.

   3.  When you see the prompt, type the name of the table to be copied
       and press Enter.

The table and all definitions of item projection, relations, relation
conditions, calculated items, functions and data access are copied.

Field Descriptions 

Table 

The name of the HP ALLBASE/BRW table.

Type 

The type of combination to be performed on the source tables, either J
(join) or M (merge).  The default is J.

Source Table 

The name of the source tables that will be used to build the table.

In HP ALLBASE/BRW a source table is the name of an IMAGE data set, the
owner_name.table_name of an HP ALLBASE/SQL table, the format name of a
KSAM or MPE file, or the name of another HP ALLBASE/BRW table defined in
the same report specification.

If you are using more than one HP ALLBASE/SQL table from the same
DBEnvironment, the tables should be listed consecutively.  This is
because HP ALLBASE/SQL queries to the same DBEnvironment are then
combined to one HP ALLBASE/SQL query by default.

If you are using an intermediate report file (an output file created by
another report), you must assign it a name here.


NOTE  For HP ALLBASE/SQL tables you must specify both the owner name and
      the table name in the Source Table field of this screen, however,
      elsewhere within HP ALLBASE/BRW you only need to specify the table
      name.

      To define a report, you need the HP ALLBASE/SQL production database
      or an HP ALLBASE/SQL test database with the same table structures,
      owner names, and access rights as the production database.  You
      must have SELECT authority on all HP ALLBASE/SQL tables and views
      you intend to specify.  In addition, you need CONNECT authority to
      the HP ALLBASE/SQL DBEnvironment.


Location 

The location of the source tables, either a database, DBEnvironment, or
file name.  These names must be qualified with group and account names if
the report is to be executed from another logon group or account.

If an IMAGE database or file is specified with an account other than the
logon account, the dictionary file in that other account is used along
with the specified database or file.

An HP ALLBASE/SQL DBEnvironment does not require a dictionary file.

An intermediate report file name must be preceded by the symbol >.

Password 

Optional.  The IMAGE database password or the file lockword, if any.  The
default for a database password is a semicolon (;)--this requires the
user to be the creator of database.  If this is a file, the default
password is blank.  See "File Lockwords/Passwords" , for more
information on how to specify passwords.

If the IMAGE database or file is not described in the data dictionary, HP
ALLBASE/BRW does not verify the location and password.

HP ALLBASE/SQL does not know passwords for DBEnvironments, tables, views,
or columns.  Access to an HP ALLBASE/SQL database is controlled via
authorities granted to the users of a DBEnvironment.  This information is
kept in the SQL System Catalog and checked against the MPE logon user
running an SQL application.  A user is identified by HP ALLBASE/SQL as
logonuser@logonaccount.

Open Join on Source Table 

Optional.  The source table for which NO_VALUE is to be used if the other
source tables contain records not found in this source table.

The default is that only records found in all source tables will be used.

Softkeys 

There are two sets of softkeys for this screen.  other keys takes you to
the other set of softkeys.  The softkeys for this screen take you to the
screen named on the key.  When you use Define Lines you need to respond
to the prompt for lineset and type.  Type the lineset type (D for detail,
P for page, R for report, or a break level number) and type H for heading
or F for footing if applicable.

MPE/iX 5.0 Documentation