HP 3000 Manuals HP 3000 Manuals
Phase G. Configuring File Tables
In Phase E, you configured files. At this point, you can configure file
tables from them. A file table is derived from one file on the host (or
remote) HP 3000. You can include all items from that file or select the
ones you want.
Adding File Tables
---------------------------------------------------------------------------------------------
| | |
| What You Do | What Happens |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-1. Type AFT in the Go to screen field | The Add File Table (AFT) screen appears. |
| and press Enter. | |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-2. Type as much information as will | Additional Add File Table fields appear. |
| uniquely identify the file from which you | |
| want to derive a file table, then press | |
| Enter. | |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-3. Type a table name and description | If you do not type a table name, the file |
| (optional). Type the name of an existing | name will be the default name for the file |
| file whose item definition is the same as | table. More Add File Table fields appear. |
| the table to be defined in the File Table | |
| field or leave the field blank if you want | |
| to create a new file definition. Press | |
| Enter. | |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-4. If the file is an SD, BRW/IRF, or | If no items are of data types zoned decimal |
| KSAM file, press Enter to include all items | (Z), packed decimal (P), integer (I), or |
| in the file table; or to list all the items | free-format numeric (N), the table |
| in SD, BRW/IRF, and KSAM files, choose Get | definition is added to the data dictionary. |
| Items f1 and type a number in the order | |
| field. Specify the items and their order, | |
| modify the Item as desired, then press | If there are items of type Z, P, I, or N, |
| Enter. | fill in the File Data Conversion screen |
| | that appears, and press Enter to add the |
| (For file table objects with more than 64 | table definition. |
| items, you'll need to limit the number you | |
| include in the file table.) | |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-5. Repeat Steps G-2 through G-4 for each | The definition of each file table is added |
| file table you want to configure. | to the data dictionary. |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-6. Choose Done f8. | The Add Table Menu appears. |
| | |
---------------------------------------------------------------------------------------------
Table 2-0. (cont.)
---------------------------------------------------------------------------------------------
| | |
| What You Do | What Happens |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-7. Repeat Steps G-1 through G-6 for each | The Administrator Utility adds the |
| file from which you want to configure file | definition of each file table to the data |
| tables. (Instead of typing AFT in Step | dictionary. |
| G-1, you may choose File Table f4 at the | |
| Add Table Menu to display the first group | |
| of Add File Table fields.) | |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-8. Choose Done f8. | The Table Menu appears. |
| | |
| If you don't want to check your | |
| configuration of file tables, skip to Phase | |
| H. | |
| | |
---------------------------------------------------------------------------------------------
Checking Configuration
---------------------------------------------------------------------------------------------
| | |
| What You Do | What Happens |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-9. Choose List All Tables f5. | The List Tables Menu appears. |
| | |
| Choose File Tables f4. | The List File Tables screen appears. This |
| | screen lists the names of all configured |
| | file tables. |
| | |
| | Secondary DBAs will see only the names of |
| | the file tables under their control. |
| | |
| Check to see that all your file tables are | |
| configured. If any file tables need to be | |
| added, use the Add File Table (AFT) screen | |
| to do so. If any file tables are not | |
| defined correctly, use the Change Table | |
| (CT) screens to correct the definition. | |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-10. Choose Done f8. | The List Tables Menu appears. |
| | |
---------------------------------------------------------------------------------------------