HP 3000 Manuals HP 3000 Manuals
Table Menu (continued)
File Data Conversion
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
when you press Enter to add (or change) the table definition.
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.
______________________________________________________________________________________________
| |
| |
| CONFIG File Data Conversion |
| Type in the information and press ENTER. |
| |
| Page of |
| |
| |
| Item Type Len Conv Decimal |
| |
| _____________ __ |
| |
| _____________ __ |
| |
| _____________ __ |
| |
| _____________ __ |
| |
| _____________ __ |
| |
| _____________ __ |
| |
| Previous Next Help |
| Page Page |
| |
______________________________________________________________________________________________
Type Data type of each item, either P (packed decimal),
Z (zoned decimal), I (integer), or N (free format
numeric).
Len Length of each item.
Conv Conversion type for the item. The possibilities
are:
P - C for Character, or
R for Real (Default)
Z - C for Character (Default), or
R for Real
I1 - R for Real
C for Character
Blank for NO convert (Default)
I2 - R for Real
C for Character
Blank for NO convert (Default)
I3 - C for Character
R for Real (Default)
I4 - C for Character
R for Real (Default)
N - I for Integer, or
- R for Real (Default)
The default conversion length for all Reals is 4
(words) and for all Integers is 2 (words).
Decimal Number of decimal digits that should follow the
decimal point. Default is 0. Field is not valid
for I or N data types.
Changing a Table Definition
Change a configured table definition already in the data dictionary at
the Change Table (CT) screen.
When you type the name of the table you want to change, the current
definition of that table appears in the same format as the Add View
Table, Add IMAGE Table, and Add File Table screen. (Each change
operation requires filling in more fields than fit the screen at one
time. Follow the instructions below to display additional fields.)
Because each type of table is defined differently, each operation has its
own screen format. The appropriate screen is selected automatically by
the Administrator Utility, which verifies the type of table when it finds
the table name in the data dictionary.
* View Tables. You can change all fields except the Table name.
* IMAGE Tables. You can change the Table Description and the
selection and Order of the Items to be included in the IMAGE
table, as well as conversion details (if any). You cannot use the
Change IMAGE Table screen to change the Table name or the Dataset
from which it is drawn.
* File Tables. You can change the Table Description field and the
selection and Order of the Items to be included in the file table,
as well as conversion details (if any). You cannot use the Change
File Table screen to change the Table name or the File from which
it is drawn.
To change the Table name of any type of table, use the Copy Table f6
function label at the Table Menu (T) to perform the rename. (See
"Copying or Renaming a Table Definition," below.)
The procedure for changing each type of table is presented separately
below. (For information about the fields in each group of Change fields,
see "Adding a View Table Definition," "Adding an IMAGE Table Definition,"
or "Adding a File Table Definition," above.)
DBA Capabilities.
If you are a secondary DBA, you can change only a table definition that
you control.
Compound Items.
If you change an IMAGE table so that it includes compound items, your PC
users will be able to access the table but not those items. After you
finish changing the IMAGE table, create one or more view tables from it.
In each view table, resolve the compound data item into simple data
items. (For details, see "Compound Items" under "Add View Tables,"
above.)
Adding or Changing IMSAM Keys.
If you are adding or changing IMSAM keys in an IMAGE database that has
IMAGE tables associated with it, you must use the Change IMAGE Table
screen to update the definition for each table that includes an IMSAM
key. (To list all tables associated with a given database, use the Show
IMAGE Database (SIMD) screen.)
To Change a View Table Definition with the Change View and Table Screen:.
1. Go to the Change Table screen by typing CT in the Go to screen
field of any menu, or by choosing Change Table f2 at the Table
Menu.
2. Type the table name and press Enter.
The first group of fields used to add a view table definition
appear, with the current definitions filled in for that table.
The screen title, Change View Table, confirms what type of table
you are changing.
(For field descriptions, see "Adding a View Table Definition,"
above. For an explanation, with examples, of view table creation,
see Appendix B. For view table syntax, see Appendix C.)
3. Type in any changes to the Sample Values Security, Table
Description, and Item Clause fields.
If you decide to leave the table definition unchanged (for all
view table fields), choose Cancel Changes f8. The screen will
clear and you can specify another table to change or return to the
Table Menu.
If you do not want to change any additional fields, skip Steps 4
and 5. Go directly to Step 6.
4. To display additional fields, choose Next Fields f3.
5. Type any changes to the Using Clause, Where Clause, and Sort
Clause fields.
To make further changes to fields no longer displayed, choose
Previous Fields f2.
6. To put the changes into effect, press Enter.
The view table definition in the data dictionary is changed.
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 Changes f8 to leave the table definition
unchanged.
7. When a blank Change Table screen reappears, you can change another
table definition.
8. To leave this screen, choose Done f8. This returns you to the
Table Menu. From there, you can go to another screen or exit the
utility.
To Change a View Table Definition with an Editor:.
1. Go to the Change Table screen by typing CT in the Go to screen
field of any menu, or by choosing Change Table f2 at the Table
Menu.
2. Type the table name and press Enter.
The first two fields used to add a view table definition appear,
with the current definitions filled in for that table. The screen
title, Change View Table, confirms what type of table you are
changing.
3. Type in any changes to the Sample Values Security and Table
Description fields.
If you decide to leave the table definition unchanged (for all
view table fields), choose Cancel Changes f8. The screen will
clear and you can specify another table change or return to the
Table Menu.
To change the other fields, press Enter.
After a few seconds, the editor screen appears.
4. To display the rest of the table definition, use the command your
editor requires for listing the contents of a document. For
example, if you are using EDIT/3000 or TDP, type List all.
(For field descriptions, see "Adding a View Table Definition,"
above. For an explanation, with examples, of view table creation,
see Appendix B. For view table syntax, see Appendix C.)
5. Type any changes to the Item Clause, Using Clause, Where Clause,
and Sort Clause.
6. To put the changes into effect, save the view table with the
editor's Save or Keep command and exit the editor.
The table definition in the data dictionary is changed.
If any clause contains an error, an error message appears and that
clause is displayed with the error highlighted. To correct the
error, return to the editor by choosing Edit Again f1. Type in
the correct information, save the definition, and exit the editor.
7. When a blank Change Table screen reappears, you can change another
table definition.
8. To leave this screen, choose Done f8. This returns you to the
Table Menu. From there, you can go to another screen or exit the
utility.
To Change an IMAGE Table Definition:.
1. Go to the Change Table screen by typing CT in the Go to screen
field of any menu, or by choosing Change Table f2 at the Table
Menu.
2. Type the table name and press Enter.
The first group of fields used to add an IMAGE table definition
appears with the current definitions filled in for that table. A
new screen title, Change IMAGE Table, confirms which type of table
you are changing.
(For field descriptions, see "Adding an IMAGE Table Definition,"
above.)
3. Type in any changes to the Table Description field.
If you decide to leave the table definition unchanged (all IMAGE
table fields), choose Cancel Changes f8. The screen will clear
and you can specify another table to change or return to the Table
Menu.
4. To display additional fields, 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 fields appear.
5. Type in any changes to the Order and Item fields.
The Item fields display a list of all items currently included in
the IMAGE table (with their Order fields filled in), followed by
the remaining items in the dataset (with blank Order fields).
If you decide at this point to leave the table unchanged, choose
Cancel Changes f8. (See Step 3.)
To redefine the subset of items to include in the table, use one
or more of the following methods:
* Type a number in the Order field of each item you want
included, up to 64.
* 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 with1. 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.
6. To put the changes into effect, press Enter.
If no items are of data types zoned decimal (Z), packed decimal
(P), or integer (I), the table definition is changed in the data
dictionary.
If any zoned (Z), packed (P), or integer (I) items were selected
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 packed and
zoned data types.) Fill in the IMAGE Data Conversion screen and
press Enter. The table definition is changed in 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 Changes f8 to leave the table definition
unchanged.
7. When a blank Change Table screen reappears, you can change another
table definition.
8. To leave this screen, choose Done f8. This returns you to the
Table Menu. From there, you can go to another screen or exit the
utility.
To Change a File Table Definition:.
1. Go to the Change Table screen by typing CT in the Go to screen
field of any menu, or by choosing Change Table f2 at the Table
Menu.
2. Type the table name and press Enter.
The first group of fields used to add a file table definition
appear, with the current definitions filled in for that table.
The screen title, Change File Table, confirms what type of table
you are changing. (For field descriptions, see "Adding a File
Table," above.)
3. Type in any changes to the Table Description field.
If you decide to leave the table definition unchanged (for all
file table fields), choose Cancel Changes f8. The screen will
clear and you can specify another table to change or return to the
Table Menu.
4. To display additional fields, 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 table type is recorded.
If the attempt fails because the file does not exist, the file
definition is assumed to be correct and additional fields appear.
5. Type any changes to the Order, Item, and item attribute fields.
The Item fields display a list of all items currently included in
the file table (with their Order fields filled in). KSAM keys are
listed with default key names (Key1, Key2, and so on).
If the file is an SD, BRW/IRF, or KSAM file, the items defined in
the file that were not configured are listed after the items
selected for the table.
If you decide at this point to leave the table unchanged, choose
Cancel Changes f8.
To redefine the subset of items to include in the table, use one
or more of the following methods:
* Type a number in the Order field of each item you want
included, up to 64.
* 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 with1. 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.
6. To put the changes into effect, 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
in the data dictionary is changed.
If any zoned (Z), packed (P), integer (I), or free-format numeric
(N) items were selected for the table, the File Data Conversion
screen appears. Here you indicate how to convert these data types
for display and manipulation by the PC user. Fill in the File
Data Conversion screen and press Enter. The file table definition
is changed in 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 Changes f8 to leave the table definition
unchanged.
Once the File Data Conversion screen reappears, cancel is no
longer an option.
7. When a blank Change Table screen reappears, you can change another
table definition.
8. To leave this screen, choose Done f8. This returns you to the
Table Menu. From there, you can go to another screen or exit the
utility.
Deleting a Table Definition
Delete an unwanted table definition at the Delete Table (DT) screen.
Impact on PC Users.
Deleting a table has no effect on a user currently accessing a configured
table. The user is working from a copy of the data created before the
table was deleted.
The next time this user or another user tries to access the same
configured table, however, an error message will appear.
You cannot delete any configured table from which a view table is
derived. (See the Note below.) However, if you want to prevent such a
configured table from appearing on your PC user's Remote Tables screen,
assign it to an empty access group by using the Add/Delete Table Security
by Table (ADTS) screen.
NOTE You cannot delete any configured table that is named in the Using
Clause of a view table definition. You must delete or change the
view table before you can delete a table from which it is derived.
Use the Delete Table (DT) or Change Table (CT) screens. (See the
following procedure or to "To Change a View Table Definition:",
above.)
DBA Capabilities.
If you are a secondary DBA, you can delete only a table definition that
you control.
To Delete a Table Definition:.
1. Go to the Delete Table screen by typing DT in the Go to screen
field of any menu, or by choosing Delete Table f3 at the Table
Menu.
2. Type the name of the table whose definition you want to delete.
3. Press Enter.
The Administrator Utility looks through the data dictionary for
the table and any view tables that name that table in their Using
Clause.
If there are no view tables associated with the specified table,
it is deleted from the dictionary. Also deleted are all table
security and item security associated with the specified table.
If you did not first delete such view tables, an error message
appears and the deletion does not take place.
4. When the screen clears, you can delete another table.
5. To leave this screen, choose Done f8. This returns you to the
Table Menu. From there, you can go to another screen or exit the
utility.