HP 3000 Manuals HP 3000 Manuals
How the Utility Works
For each Dictionary/3000 data dictionary you want to work with, you
specify the data dictionary on the Dictionary/3000 Information screen and
the databases you want translated on the Database Information screen.
The Translator Utility opens each database to verify the correctness of
what you've typed in. It then adds the definition of the database to the
Information Access data dictionary (unless it's already defined),
followed by the definitions, as IMAGE tables, of all the datasets defined
in the Dictionary/3000 data dictionary for the specified database.
The outcome of each of these actions is written to your terminal as they
are performed. The same information is written to a log file called
TRANSLOG. This file can be printed out from the Dictionary/3000
Information screen just before exiting, or examined later in an editor.
Limitations
This brief description of the Translator Utility's operation suggests
some of its limitations:
* It tries to define, as IMAGE tables, all the datasets defined in
the Dictionary/3000 data dictionary for the databases you
selected. After it has finished, you may need to use the Delete
Table (DT) screen in the Administrator Utility to delete IMAGE
tables you have no need for in Access Server.
* It gives the IMAGE table the same name as the dataset. If you
want to use a different name, you'll need to rename the table
using the Copy Table (COT) screen in the Administrator Utility.
* It will not add an IMAGE table if there is a table already defined
with a name identical to the dataset name. You can use the Add
IMAGE Table (AIMT) screen to configure this IMAGE table with a
unique name.
* If any items in the dataset are of typed zoned or packed decimal,
it will add these items with default conversion types. If
necessary, you can use the Change Table (CT) screen to modify any
of these default values.
* It will not add an IMAGE table if the dataset contains more than
64 items. You'll need to use the Add IMAGE Table (AIMT) screen to
add such a dataset, specifying which items to include in one or
more IMAGE tables.
Regardless of these limitations, you should be able to use the Translator
Utility to automate most of the translation effort, then use the
Administrator Utility to check the result and make any necessary
adjustments.
DBA Capabilities
If you are either the primary DBA or a secondary DBA, you can use the
Translator Utility to add Dictionary/3000 information to your Information
Access data dictionary.
However, once information has been translated and defined as an IMAGE
table, that table is controlled by the DBA that did the translation. If
you are the primary DBA, you can use ALL translated IMAGE tables. If you
are a secondary DBA, you can only use the ones you originally translated
or had reassigned to you.
If you are the primary DBA running the Translator Utility to add tables
for a configured database (regardless of who controls it), the tables are
added and the controller remains the same.
However, if you are a secondary DBA adding tables for a configured
database (regardless of who controls it), the utility checks to see who
controls the database. If you are the controller of the database, the
tables are added. Otherwise, the error message,
Database name.group.account is controlled by another DBA
(AC20211)
is written to the Translator Utility log file, followed by a message that
tells you that no tables have been added.