HP 3000 Manuals HP 3000 Manuals
F : Configuring IMAGE Tables Next, derive IMAGE tables from two of the IMAGE datasets in database SAMPL2--datasets PRODUCT-MASTER and INVENTORY. You'll be using the data in Worksheet 1, Figure 2-2. For each IMAGE table, you must tell Access Server which dataset contains the information you want. Then you specify which items of information to include in the table and how to include them. Later, these two IMAGE tables will be used to construct view tables that will redefine this information in the form required for dBASE II on a PC. Here's what the system will look like when you add these IMAGE tables:Figure 2-7. IMAGE Tables PRODUCT-MASTER and INVENTORY Added ___________________________________________________________ | | | References in this Learning manual: | | Before You Begin: | | Description of Sample Databases | | Lesson 1:D, How the Data Dictionary is Configured| | Figure 2-2, Worksheet 1 Completed | | Appendix B, Schema for SAMPL2 Database | | | | References in Information Access Server: Database | | Administration: | | Chapter 5, Configuring Tables: | | Table Menu | | Adding an IMAGE Table Definition | ___________________________________________________________ Going Directly to a Screen --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | To add an IMAGE database, you stepped | | | through the menu path until the data entry | | | screen for adding appeared, then back | | | through the path to the Configuration Main | | | Menu. | | | | | | There is a shortcut to reach most screens | | | more directly. | | | | | | Each menu and screen that can be reached | | | directly has a screen name which is an | | | abbreviation of its full title. To go to | | | any menu, you need only type this short | | | name in the Go to screen field, and press | | | Enter. | | | | | | You'll use the shortcut from now on, except | | | when the screen you want can be chosen by | | | function label from the current menu. | | | | | ---------------------------------------------------------------------------------------------
NOTE A Go to screen field is found on every menu: Go to screen The Screen Map in Appendix C shows the relationships between menus and screens, as well as the screen names you can use in the Go to screen field. You can also see an on-line listing of the screen names by typing ? in the Go to screen field on any menu and pressing Enter.
--------------------------------------------------------------------------------------------- | | | | The cursor is at the Go to screen field. | | | | | | F-1. Type AIMT and press Enter. | You have told the Administrator Utility to | | | go directly to the Add IMAGE Table (AIMT) | | | screen. (Look for its short screen name in | | | the upper right corner of the screen | | | banner.) | | | | | Here you'll define two IMAGE tables from | | | the IMAGE datasets of database SAMPL2 which | | | you just configured. (Later, you'll rework | | | this data into view tables.) | | | | | --------------------------------------------------------------------------------------------- Adding an IMAGE TableGo to screen AIMT --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | At the Add IMAGE Table screen: | | | | | | F-2. Type SAMPL2 in the Database field. | This tells the Administrator Utility to | | | configure IMAGE tables from database | | (You can leave the other fields blank, | SAMPL2. No entry is required in the Remote | | since the name uniquely identifies which | System field, because SAMPL2 is a host | | database you want from all databases | database. | | configured in the data dictionary.) | | | | | | F-3. Press Enter. | When you press Enter, the Administrator | | | Utility finds the database definition in | | | the data dictionary. | | | | | | To define an IMAGE table, more fields are | | | required than fit on one screen display. | | | Additional fields appear so you can specify | | | a dataset from which to derive the IMAGE | | | table. | | | | --------------------------------------------------------------------------------------------- | | | | The Dataset field shows the first of two | | | dataset names from database SAMPL2. This | | | name, PRODUCT-MASTER, appears as a default | | | in the Table field as well. | | | | | | You could type in a different table name, | This will give the IMAGE table the same | | but instead, leave the default. | name as the dataset from which it is | | | derived. | | | | | F-4. Tab to the Table Description field. | Additional fields appear so you can choose | | Type MASTER PRODUCT TABLE, then press | the items to include in the IMAGE table. | | Enter. | | | | | --------------------------------------------------------------------------------------------- Table 2-0. (cont.) --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | F-5. Choose: | The Administrator Utility retrieves the | | | names of all the items in this dataset. | | Get f1 | | | Items | | | | | | F-6. Then choose: | A number is automatically placed in the | | | Order field for each item. This indicates | | Order & f4 | that all items from this dataset are to be | | Incl All | included, in the same order as in the | | | dataset. (You could have chosen, instead, | | | a subset of the items to include in the | | | IMAGE table, as you'll do in Lesson 5:B. | | | You could also have reordered them.) | | | | --------------------------------------------------------------------------------------------- | | | | F-7. To configure the IMAGE table | The Administrator Utility displays a new | | PRODUCT-MASTER, press Enter. | screen titled IMAGE Data Conversion. This | | | screen is displayed automatically when the | | | utility detects zoned, packed, or integer | | | items. | | | | | | (If none of the items chosen were zoned, | | | packed, or integer items, pressing Enter | | | would have added the table definition | | | without displaying this screen.) | | | | --------------------------------------------------------------------------------------------- Data Conversion --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | At the IMAGE Data Conversion screen, you | The IMAGE items are displayed with their | | indicate how to convert zoned, packed, and | attributes, plus default conversion type | | integer items for PC use. | and decimal point placement. In this case, | | | the items UNIT-COST and PRICE are displayed | | | with a Conv Type of R (real) and 0 places | | | after the Decimal point. | | | | | Change some of the defaults: | | | | | | F-8. Tab past the Conv field (which has | Now the definition of the IMAGE table | | the appropriate value) and replace the 0 | PRODUCT-MASTER is added to the data | | with a 2 in both of the Decimal fields, | dictionary. | | then press Enter. | | | | | --------------------------------------------------------------------------------------------- Table 2-0. (cont.) --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | | You have defined the table by getting and | | | including all the item names. You have | | | instructed Access Server to convert all | | | packed decimal items to a real number with | | | two (2) digits placed after the decimal. | | | This conversion will occur whenever the | | | data is retrieved from the IMAGE dataset. | | | | | | The Add IMAGE Table screen reappears. | | | | --------------------------------------------------------------------------------------------- Adding Another IMAGE Table --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | The name of the next dataset, INVENTORY, is | | | now displayed as a default in the Dataset | | | and Table fields. The Administrator | | | Utility automatically cycles through all | | | existing datasets so you can easily define | | | tables from them. | | | | | | In Step F-5, you used Get Items f1 to | | | choose which items to include in the IMAGE | | | table PRODUCT-MASTER. | | | | | | Now use a simpler method of including all | | | the items from a dataset as you configure | | | the IMAGE table INVENTORY. | | | | | | F-9. Leave the Table Description field | The first Enter brings the dataset | | blank (it's optional). Press Enter once to | INVENTORY into the next group of fields. | | accept the defaults at this screen. | | | | | | F-10. Press Enter again to include all the | The second Enter gets all the items and | | items. | includes them in default order. Pressing | | | Enter twice produces the same result as | | | using the two function labels Get Items | | | f1 and Order & Incl All f4 and pressing | | | Enter. | | | | | | Once again, the Administrator Utility | | | detects items that may need conversion and | | | displays the IMAGE Data Conversion screen. | | | | --------------------------------------------------------------------------------------------- Table 2-0. (cont.) --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | The default conversion values are what you | | | want for the item ON-HAND-QTY. | | | | | | F-11. Press Enter to accept the defaults. | The definition of the IMAGE table INVENTORY | | | is added to the data dictionary. | | | | | | The table name is the dataset name by | | | default. All item names in the dataset are | | | defined as items in the table. When data | | | is retrieved from the dataset INVENTORY, | | | packed decimal values will be converted to | | | real numbers with no decimal digits. | | | | --------------------------------------------------------------------------------------------- | | | | F-12. Choose: | The first group of Add IMAGE Table fields | | | reappear. | | Done f8 | | | | | | | | | (If you had configured another database, | | | say SAMPL1, and wanted to configure IMAGE | | | tables from its datasets, you could do so | | | here.) | | | | | | F-13. To leave this data entry screen and | The Add Table Menu appears. | | return to a menu from which you can go to | | | the next task, choose: | You have configured several IMAGE tables. | | | You returned to the Add Table Menu, from | | Done f8 | which the screen for the next task can be | | | reached. | | | | --------------------------------------------------------------------------------------------- Summary In this exercise, you learned how to: * Get and include all dataset items in an IMAGE table, using two different methods. * Specify the conversion of packed IMAGE data when it is retrieved through Access PC.
![[]](../../pic3k/M012040/FFN273c50.gif)
![[]](../../pic3k/M012040/FFN293c50.gif)