HP 3000 Manuals HP 3000 Manuals
HP ALLBASE/BRW Dictionary File (BRWDIC)
These are the major features of BRWDIC:
* It supports HP Dictionary/3000, HP System Dictionary, HP
Application Dictionary, HP Information Access data dictionary, and
user-generated dictionaries.
* It lets you use multiple data dictionaries in one report. All
five data dictionary generators--HP Dictionary/3000, HP System
Dictionary, HP Application Dictionary, HP Information Access data
dictionary, and user-generated dictionaries--can be used in
combination.
* Reports can be automatically recompiled after changes to the
BRWDIC.
Removing the Data Dictionary
HP ALLBASE/BRW programs (other than the dictionary generators) use only
the BRWDIC files and never access the original dictionaries, so the data
dictionaries can be removed from the system after the BRWDIC is created.
Also, if you want to run reports on another HP 3000 that does not have HP
ALLBASE/BRW installed, see "Requesting Reports with BRWEXEC" in Chapter
11 for information on running HP ALLBASE/BRW reports on other HP 3000s.
Rules for creating and modifying BRWDIC
* You cannot directly modify a BRWDIC dictionary file. That is, if
the data dictionary is altered, you must prepare a new BRWDIC file
from the modified data dictionary.
* BRWDIC accepts names up to 20 characters in length (since that is
the maximum that HP ALLBASE/BRW can accept).
Using BRWDLIST
You can print out the contents of the BRWDIC using the program BRWDLIST.
This will print the information to a temporary file called RPRINT.
To print the contents of BRWDIC
1. Run BRWDLIST:
:RUN BRWDLIST.PUB.SYS
2. Save the RPRINT file.
:SAVE RPRINT
[REV BEG]
Using Multiple Data Dictionaries or a Central Dictionary
You can combine data described in several dictionaries in a single
report. This is especially useful if you want to combine data from
different applications in one report. Typically, each application uses
its own dictionary. Also, it is typical that each application uses a
separate account on the system. Therefore, each account that contains
databases or files used in reports must have its own BRWDIC dictionary.
Which BRWDIC file does HP ALLBASE/BRW use?.
HP ALLBASE/BRW accesses the BRWDIC file in the PUB group of the account
for the database or file named on the Define Table screen. If you name
multiple databases or files from different accounts, HP ALLBASE/BRW
accesses the corresponding BRWDIC file in the account where each database
or file resides. In other words, HP ALLBASE/BRW accesses the appropriate
BRWDIC file for each of the databases or files, as long as you have one
dictionary in each account.
What about a Central Dictionary?.
If you have one central BRWDIC dictionary that you want to be used for
all databases, regardless of which account they are in, you can use file
equations in the logon UDCs of each of the three accounts. Here is a
sample of some file equations you could customize for your accounts:
FILE BRWDIC.PUB = BRWDIC.PUB.DICTACCT
FILE BRWDIC.PUB.FINANCE = BRWDIC.PUB.DICTACCT
FILE BRWDIC.PUB.PRODUCTN = BRWDIC.PUB.DICTACCT
FILE BRWDIC.PUB.ORDERS = BRWDIC.PUB.DICTACCT
With these file equations, you could use the databases and files in the
FINANCE, PRODUCTN, and ORDERS accounts and they would all access the
central dictionary in the DICTACCT. If you wanted to prevent the PRODUCTN
account from having access to files in the FINANCE account, omit the file
equation for the FINANCE account when you create the logon UDCs for the
PRODUCTN account.
Another solution would be to create a BRWDIC file and copy it to each of
the accounts. However, since the BRWDIC file is generally quite large,
this may not be the best solution.[REV END]
Multiple BRWDIC in the same account.
HP ALLBASE/BRW always looks in the PUB group of the account where the
data is located (given on the Define Table screen) for BRWDIC.
For two or more BRWDICs to exist in
the same account, they must be given different names, as shown in the
steps below:
[REV BEG]
To have two BRWDIC files in the same account
1. Create the first BRWDIC file, using any of the dictionary
generators:
:RUN BRWxxx.PUB.SYS
The result is a file named BRWDIC.PUB.logonaccount.
2. To create the second BRWDIC file, first use a file equation and
then run the dictionary generator:
:FILE BRWDIC.PUB = BRWDICx.PUB
:RUN BRWDICxxxx.PUB.SYS
The result is a file named BRWDICx.PUB.logonaccount.
3. Remove the file equation for BRWDIC.PUB using the RESET command:
:RESET BRWDIC.PUB
4. Use two file equations to simulate a separate account for one of
the data sources and for one of the BRWDIC files:
:FILE yourdb.yourgrp.dummyaccount = yourdb.yourgrp
:FILE BRWDIC.PUB.dummyaccount = BRWDICx.PUB
The dummy account does not need to be an existing account.
You can include this file equation in the logon UDC for the
account where the data sources are located. Or, you can include
the file equations in the report job file so that the file
equation is set when the job logs on. See Chapter 11 for a
description of report job files.
NOTE When you specify the yourdb data source on the Define Table screen,
you must use the dummyaccount in the pathname. For instance, if
your file equation is:
FILE TOYSDB.PUB.FINANCEX = TOYSDB.PUB
Then you would specify TOYSDB.PUB.FINANCEX in the location field on
the Define Table screen.
Leave the account blank when specifying data defined in the BRWDIC
that is not equated to the dummy account. HP ALLBASE/BRW looks for
BRWDIC.PUB and finds BRWDIC.PUB in the logon account.
[REV END]