HP 3000 Manuals HP 3000 Manuals
Table Menu (continued)
Adding an IMAGE Table Definition
An IMAGE table is a table configured directly from information stored in
one IMAGE dataset on the host (or remote) HP 3000. You can include all
items from that dataset or select the ones you want.
Add the definition of an IMAGE table to the data dictionary at the Add
IMAGE Table (AIMT) screens, shown on the next two pages.
Table 5-2 describes the fields in the Add Image Table screens.
DBA Capabilities.
If you are a secondary DBA, you can define an IMAGE table only from a
database that you control.
IMSAM Keys.
Access Server supports IMSAM keys in IMAGE databases for users of the
OMNIDEX Information Management System. For information about how IMSAM
keys are used, see the OMNIDEX Information Management System Reference
Manual.
IMSAM supports a feature called composite keys, which are IMSAM keys
constructed from parts of one or more data items in a dataset. In Access
Server, composite keys look like any other IMAGE data item. They appear
in the Add IMAGE Table screens using the item names assigned to them by
the IMSAM maintenance utilities. (For examples of using composite keys,
see "IMSAM Composite Keys" in Appendix B.)
______________________________________________________________________________________________
| |
| |
| CONFIG Add IMAGE Table Screen: AIMT |
| Type in the information and press ENTER. |
| |
| |
| DataBase.Group.Account . . |
| |
| |
| Remote System |
| |
| |
| Database Password |
| |
| |
| |
| |
| |
| |
| |
| Help Done |
| |
| |
______________________________________________________________________________________________
______________________________________________________________________________________________
| |
| |
| CONFIG Add IMAGE Table |
| Type in the information and press ENTER. |
| |
| |
| Data.Group.Account ____ . ______ . ______ |
| |
| Remote System ______ |
| |
| Database Password ______ |
| |
| Dataset of |
| |
| Table |
| |
| |
| |
| Table Description |
| |
| Previous Next Help Done |
| Dataset Dataset |
| |
______________________________________________________________________________________________
______________________________________________________________________________________________
| |
| |
| CONFIG Add IMAGE Table |
| Type in the information and press ENTER. |
| |
| |
| Dataset _____________ Table _____________ Page of |
| |
| Order Item Order Item Order Item |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Get Previous Next Order & Display Go To Help Cancel |
| Items Page Page Incl All In Order Page Add |
| |
______________________________________________________________________________________________
Table 5-2. Add IMAGE Table Screen Fields
--------------------------------------------------------------------------------------------
| | |
| Field | Description |
| | |
--------------------------------------------------------------------------------------------
| | |
| Database | Name of the database containing the dataset(s) of interest. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Group | MPE group where the database resides. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Account | MPE account where the database resides. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Remote System | Name of the remote HP 3000 system on which the database is located. |
| | Leave this field blank if the database is located on the host system. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Database | IMAGE password used to open the database. |
| Password | |
| | |
--------------------------------------------------------------------------------------------
| | |
| Dataset | Name of the dataset from which the items are to be drawn to create |
| | the IMAGE table. |
| | |
--------------------------------------------------------------------------------------------
Table 5-2. Add IMAGE Table Screen Fields (cont.)
--------------------------------------------------------------------------------------------
| | |
| Field | Description |
| | |
--------------------------------------------------------------------------------------------
| | |
| Table | Name of the IMAGE table. Default name is the name of the dataset. |
| | IMAGE table name syntax conforms to IMAGE syntax for dataset names. |
| | |
| | The name can be 1 to 16 characters long. It must begin with a |
| | letter. That letter can be followed by any of the following: the |
| | letters A through Z, the digits0 through 9, and any of the characters |
| | + - * / ? '# % & @. |
| | |
| | The following reserved words can be used for table names: AND, CASE, |
| | DEFAULT, DIV, ELSE, END, F, FALSE, IS, JOIN, LEFTJOIN, LIKE, LJ, |
| | MATCH, MOD, NOT, OR, T, and TRUE. (See "Reserved Words as Table and |
| | Item Names" under "Ground Rules" in Chapter 2.) |
| | |
--------------------------------------------------------------------------------------------
| | |
| Table | (Optional.) Phrase, up to 50 characters, to remind you and your |
| Description | users what the IMAGE table contains. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Order | Order of the item in the IMAGE table. Only items with a filled-in |
| | order number will be included in the table. |
| | |
| | To omit an item, leave this field blank. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Item | Name of an item from the IMAGE dataset named at the top of the |
| | screen. Item names must be unique. |
| | |
| | Item names cannot be Access Server reserved words. (These words are |
| | listed in the Table field definition, above.) |
| | |
| | If an item is compound, it can be included in an IMAGE table, but |
| | your PC users will not be able to access that item. After the IMAGE |
| | table has been configured, you can create one or more view tables |
| | from it. Use the view table(s) to resolve the compound data item |
| | into simple data items. ("To Add a View Table Definition" under |
| | "Adding a View Table Definition," above.) |
| | |
| | The maximum record length allowed is 2048 bytes. Determine record |
| | length by adding all item lengths. If conversion of data types is |
| | involved, the record length both before and after conversion must not |
| | exceed 2048 bytes for the table definition to be valid. |
| | |
--------------------------------------------------------------------------------------------
NOTE If you know in advance that you want to include all items as they
are ordered in the IMAGE dataset and there are no more than 64
items, you can press Enter without any need to use function keys to
display and order the items.
To Add an IMAGE Table Definition:.
Adding an IMAGE table is a three-part process:
* Identify the database you want.
* Identify the dataset from which to draw table items.
* Specify items to include in the table.
When you complete each part of the process, a new group of Add IMAGE
Table fields appears for you to begin the next part.
At the end of the entire process, the IMAGE Data Conversion screen
appears automatically if any data items need to be converted for use in
the table. (See "IMAGE Data Conversion," below.)
1. Go to the Add IMAGE Table screen by typing AIMT in any Go to
screen field, or by stepping through two menus: choose Add Table
f1 at the Table Menu, then IMAGE Table f2 at the Add Table Menu.
2. Type in as much information as will uniquely identify the
database. If, for example, you have only one database named DB1
defined in the data dictionary, then typing DB1 in the Database
field is sufficient. However, if you are a secondary DBA, you
might have to enter more fields to identify the database because a
database with the same name may be controlled by another DBA.
3. To access the database, press Enter.
An attempt is made to open the database. (If the database resides
on a remote system, the Administrator Utility performs a remote
logon unless a session already exists for the specified remote
system.)
If the attempt succeeds, additional Add IMAGE Table fields appear.
4. Identify the dataset from which you want to draw table items. The
name of the first dataset in the database is the default entry in
the Dataset field.
If you are interested in a different dataset than the default
entry, there are two ways to identify it:
* Use Next Dataset f3 and Previous Dataset f2 to cycle
through the datasets until the one you want appears.
* Type the dataset name you want. (If you choose this
method, be sure to alter the default name in the Table
field as well.)
5. Name the table. The default name, which appears in the Table
field, is the name of the dataset.
If you want to give the table a more precise or more descriptive
name, or if you are deriving more than one table from a particular
dataset, type the new name over the default.
6. If you want to include a description of the table (up to 50
characters), type it into the Table Description field. This field
is valuable for indicating table size and/or identifying search
items.
7. To display the next set of fields, press Enter.
You have two ways to specify which items (up to 64) to include in
the table and in what order they should appear.
8. To include all items from the dataset, in the order in which they
appear in the dataset, press Enter. Or,
9. To define a subset of items to include in the table, use one (or
more) of the following methods:
* Choose Get Items f1 to list all the items in the dataset.
Then type a number in the Order field of each item you want
included.
* Fill in the Order and Item fields without using function
labels.
* Choose Order & Incl All f4. This fills the Order field of
each item with a number, in the order that items are
currently listed, starting with 1. Exclude items by
blanking out their Order fields.
* Choose Display In Order f5. This sorts numbered items in
ascending order. Unnumbered items (that will be excluded
from the table) are listed after the numbered ones.
10. To create the table, press Enter.
If no items are of data types zoned decimal (Z), packed decimal
(P), or integer (I), the table definition is added to the data
dictionary.
If you selected any zoned (Z), packed (P), or integer (I) items
for the table, the IMAGE Data Conversion screen appears. Here you
indicate how to convert these data types for display and
manipulation by the PC user. (IMAGE requires that application
programs handle the placement of the decimal point for zoned
decimal and packed decimal data.) Fill in the Conversion screen
(see "IMAGE Data Conversion," below) and press Enter. The table
definition is added to the data dictionary.
If any field contains an error, an error message appears and that
field is highlighted. Type in the correct information and press
Enter, or choose Cancel Add f8 to cancel the table definition
without adding it to the data dictionary.
11. When the screen clears to display the previous group of fields,
you can add another table definition derived from the specified
database.
The name of the next dataset in the database is the new default
entry in the Dataset and Table fields.
Repeat this process (Steps 4 through 11) until you have defined
all the tables you want from this database.
12. To leave this screen, choose Done f8 to go to the first Add
IMAGE Table screen, then choose Done f8 to return to the Add
Table Menu. From there, you can go to another screen or exit the
utility.
IMAGE Data Conversion.
If any items you specify to include in an IMAGE table are of the types
zoned decimal, packed decimal, or integer, the IMAGE Data Conversion
screen appears when you press Enter to add (or change) the table
definition.
______________________________________________________________________________________________
| |
| |
| CONFIG IMAGE Data Conversion |
| Type in the information and press ENTER. |
| Page of |
| |
| Item Type Len Sub Conv Decimal |
| |
| _____________ __ __ |
| |
| _____________ __ __ |
| |
| _____________ __ __ |
| |
| _____________ __ __ |
| |
| _____________ __ __ |
| |
| _____________ __ __ |
| |
| _____________ __ __ |
| |
| Previous Next Help |
| Page Page |
| |
______________________________________________________________________________________________
This screen lets you indicate how these items should be converted for
display and manipulation by PC users. In addition to the item name, the
screen displays the following information about each item:
Type Data type of each item, either Z (zoned decimal), P (packed decimal),
or I (integer). The following table lists each of these Access
Server type designators, its meaning, its IMAGE data type equivalent,
the units of length in which it is measured, and the length values
acceptable for a configured Access Server table.
DATA IMAGE
TYPE MEANING EQUIV LENGTH LENGTH VALUES
Z Zoned Z bytes 2 to 26
P Packed P half-bytes 2 to 28
I Integer I,J,K2,K4 words 1,2,3, or 4
Integer includes I1, I2, I3, I4, J1, J2, J4, K2, and K4. All
integers go through data conversion. If the integer is an I1, I2,
J1, or J2, you have the option of specifying either R to convert into
real, C to convert into character, or a blank, which means no
conversion takes place. If the integer is an I3, I4, J4, or K4, you
must specify either R (the default) to convert into real or C to
convert into character.
Len Length of each item.
Sub Number of sub-items in a compound data item. One or more view tables
can be configured from any IMAGE table with compound items in order
to resolve them into simple data items. (For details, see "Adding a
View Table Definition," above.)
The remaining two columns of fields contain default values for the data
type to which each item should be converted and the number of digits to
the right of the decimal point. You can change any defaults.
Here are the possibilities:
Conv How the item is converted for display and manipulation by your PC
users, indicated by the letter C, R, or a blank.
C (default for zoned decimal) means convert the zoned decimal,
packed decimal, or integer item to characters.
R (default for packed decimal, I3, I4, or J4) means convert the
zoned decimal, packed decimal, or integer item to a real value of
four words in length.
A blank (default for integer) means to not convert I1, I2, J1, or J2
item.
Decimal Number of decimal digits that should follow the decimal point.
Default is 0.
NOTE If your users are planning to download a table for use in a PC
application (such as Lotus 1-2-3) involving arithmetic
manipulation, then you'll need to use R (real) for zoned, packed,
and I3, I4, and J4 conversions.
Maintaining Security.
If you are the primary DBA and you need to add an IMAGE table containing
sensitive information and don't want to shut any users out of Access
Server, be aware that the access group (ADMIN) to which you belong has a
capability of 3.
If the primary DBA runs Information Access on a PC (or the Host Batch
Facility on the HP 3000) and configures an IMAGE table, Access Server
immediately assigns the access group ADMIN to the newly configured table.
The primary DBA can then go back into the Administrator Utility and
adjust the table and item security without being concerned about
unauthorized users accessing the table.
Adding a File Table Definition
A file table is a table configured directly from information stored in a
file on the host (or remote) HP 3000. You can include all items from
that file or select the ones you want.
Add the definition of a file table to the data dictionary at the Add File
Table (AFT) screen, shown below.
Table 5-3 describes the Add File Table screen fields.
DBA Capabilities.
If you are a secondary DBA, you can define a file table only from a file
that you control.
______________________________________________________________________________________________
| |
| |
| CONFIG Add File Table Screen: AFT |
| Type in the information and press ENTER. |
| |
| |
| File.Group.Account . . |
| |
| |
| Remote System |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Help Done |
| |
| |
______________________________________________________________________________________________
______________________________________________________________________________________________
| |
| |
| CONFIG Add File Table |
| Type in the information and press ENTER. |
| |
| |
| File.Group.Account ____ . ______ . ______ |
| |
| |
| Table |
| |
| |
| Table Description |
| |
| |
| |
| (Specify a file table from which to copy the item definitions.) |
| File Table |
| |
| |
| Help Done |
| |
| |
______________________________________________________________________________________________
______________________________________________________________________________________________
| |
| |
| CONFIG Add IMAGE Table |
| Type in the information and press ENTER. |
| |
| |
| Table ______________ Page of |
| |
| Order Item Start Type Len |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Get Previous Next Order & Display Go To Help Cancel |
| Items Page Page Incl All In Order Page Add |
| |
______________________________________________________________________________________________
Table 5-3. Add File Table Screen Fields
--------------------------------------------------------------------------------------------
| | |
| Field | Description |
| | |
--------------------------------------------------------------------------------------------
| | |
| File | Name of the file containing the data of interest. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Group | MPE group where the file resides. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Account | MPE account where the file resides. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Remote System | Name of the remote HP 3000 system on which the file is located. |
| | Leave this field blank if the file is located on the host system. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Table | Name of the file table. A default name (that will be the same as the |
| | file name) will be provided. The table name conforms to the syntax |
| | for for other table types, which conforms to IMAGE syntax for |
| | datasets. |
| | |
| | The name can be 1 to 16 characters long. It must begin with a |
| | letter. That letter can be followed by any of the following: the |
| | letters A through Z, the digits 0 through 9, and any of the |
| | characters + - * / ? ' # % & @. |
| | |
| | The following reserved words can be used for table names: AND, CASE, |
| | DEFAULT, DIV, ELSE, END, F, FALSE, IS, JOIN, LEFTJOIN, LJ, LIKE, |
| | MATCH, MOD, NOT, OR, T, and TRUE. (See "Reserved Words as Table and |
| | Item Names" under "Ground Rules" in Chapter 2.) |
| | |
--------------------------------------------------------------------------------------------
| | |
| Table | (Optional) Phrase, up to 50 characters, to remind you and your users |
| Description | what the file table contains. |
| | |
--------------------------------------------------------------------------------------------
| | |
| File Table | (Optional) Name of an existing file table whose item definition is |
| | the same as the table to be defined. This function is useful when |
| | configuring two tables from different files with the same structure. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Order | Order of the item in the file table. Only items with a filled-in |
| | order number will be included in the table. To omit the item, leave |
| | this field blank. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Item | Name of the item. Item names: |
| | |
| | (1) Must be unique within this table |
| | |
| | |
| | (2) Cannot be reserved words as listed for table names |
| | |
| | |
| | (3) Must follow same syntax as table names |
| | |
--------------------------------------------------------------------------------------------
Table 5-3. Add File Table Screen Fields (cont.)
--------------------------------------------------------------------------------------------
| | |
| Field | Description |
| | |
--------------------------------------------------------------------------------------------
| | |
| Start | Beginning byte offset for the item in the physical file record, |
| | starting at one. Overlapping items are acceptable. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Type | Data type for the items in the file. Valid types are: |
| | |
| | C - Character |
| | I - Integer |
| | R - Real |
| | P - Packed |
| | Z - Zoned |
| | N - Free Format Numeric |
| | L - Logical (Unsigned Integer) |
| | |
| | |
| | Data type N is an ASCII representation of a numeric value. Decimals |
| | and commas are allowed. Value can be exponential notation with |
| | either L or E. |
| | |
| | Items of type N can also be specified with the SUB function. (For |
| | more information, see "Item Clause" in Appendix B, "Constructing View |
| | Tables.") |
| | |
--------------------------------------------------------------------------------------------
| | |
| Len | Length of the item in the physical file. Item lengths are restricted |
| | by: |
| | |
| | (1) Maximum length of 256 bytes |
| | |
| | |
| | (2) Record length of a configured table has a maximum length of 2048 |
| | bytes |
| | |
| | Units for the lengths are dependent on the type: |
| | |
| | C - bytes (1 - 256) |
| | I - words (1, 2, 3, or 4) |
| | R - words (2 or 4) |
| | P - half-bytes (nibbles) (2 - 28, even only) |
| | Z - bytes (2 - 26) |
| | N - bytes (1 - 256) |
| | L - words (1) |
| | |
--------------------------------------------------------------------------------------------
To Add a File Table Definition:.
Adding a file table is a three-part process:
* Identify the file data source you want.
* Specify the table name and optionally, the file table from which
to copy an item definition.
* Specify items to include in the table.
When you complete each part of the process, a new group of Add File Table
fields appears for you to begin the next part.
At the end of the entire process, the File Data Conversion screen appears
automatically if any data items need to be converted for use in the
table. (See "File Data Conversion," below.)
1. Go to the Add File Table screen by typing AFT in any Go to screen
field, or by stepping through two menus: choose Add Table f1 at
the Table Menu, then File Table f3 at the Add Table Menu.
2. Type in as much information as will uniquely identify the file.
If, for example, you have only one file named FILE1 defined in the
data dictionary, typing FILE1 in the File field is sufficient.
However, if you are a secondary DBA, you might have to enter more
fields to identify the file because a file with the same name may
be controlled by another secondary DBA.
3. To access the file, press Enter.
An attempt is made to open the file. (If the file resides on a
remote system, the Administrator Utility performs a remote logon
unless a session already exists for the specified remote system.)
If the attempt succeeds, the file type is checked and saved.
If it fails, the file definition is assumed to be correct.
Additional Add File Table fields are then displayed.
4. Name the table. The file name will be the default table name for
the file table. If you want to change the default name, type in
the new name over the default.
5. If you want to include a description of the table (up to 50
characters), type it into the Table Description field. This field
is valuable for indicating table size and/or identifying KSAM
keys.
6. If you want to copy an item definition from an existing file
table, type the name of that file table in the File Table field.
Otherwise, leave the File Table field blank.
_________________________________________________________________
NOTE The File Table field does not appear on any of the other
file screens.
_________________________________________________________________
7. To display the next set of fields, press Enter.
You have two ways to define the items (up to 64) to include in the
table and in what order they should appear.
8. If the file is an SD, BRW/IRF, or KSAM file and you wish to
include all items (up to 64) in the order in which they appear in
the file, press Enter. Or,
9. To define a subset of items to include in the table, use one (or
more) of the following methods:
* Choose Get Items f1 to list all the items in SD and
BRW/IRF files or all the keys in KSAM files. If File Table
is specified, the items will automatically be displayed
with no order number. You can type a number in the Order
field of each item you want included, up to 64.
The Get Items function label will only be displayed if
items can be retrieved. BRW/IRF and SD files have items in
their user labels.
Keys are unnamed in KSAM files, so Access Server gives them
default names Key1, Key2...Key6, and so on.
Regular MPE data files will not cause the Get Items
function label to be displayed.
* Fill in the Order, Item, and item attribute fields without
using function labels.
* Choose Order & Incl All f4. This fills the Order field of
each item with a number, in the order that items are
currently listed, starting with 1. Exclude items by
blanking out their Order fields.
* Choose Display In Order f5. This sorts numbered items in
ascending order. Unnumbered items (that will be excluded
from the table) are listed after the numbered ones.
10. To create the table, press Enter.
If no items are of data types zoned decimal (Z), packed decimal
(P), integer (I), or free-format numeric (N), the table definition
is added to the data dictionary. (Integer includes I1, I2, I3,
and I4.)
If any zoned (Z), packed (P), integer (I), or free-format numeric
(N) items are defined in the table, the File Data Conversion
screen appears.
This screen lets you indicate how these items should be converted
for display and manipulation by the PC user. Fill in the File
Data Conversion screen and press Enter. The table definition is
added to the data dictionary.
If any field contains an error, an error message appears and that
field is highlighted. Type in the correct information and press
Enter, or choose Cancel Add f8 to abandon the table definition
without adding it to the data dictionary.
Once the File Data Conversion screen appears, the cancel is not
possible.
11. When the screen clears to display the previous group of fields,
you can add another table definition derived from the specified
file.
Repeat this process (Steps 4 through 11) until you have defined
all the tables you want from this file.
12. To leave this screen, choose Done f8 to go to the first Add File
Table screen, then choose Done f8 to return to the Add Table
Menu. From there, you can go to another screen or exit the
utility.
NOTE After adding a file table definition, you might want to run the
Synchronization feature against it to check for possible item
definition problems.