HP 3000 Manuals HP 3000 Manuals
B : IMAGE Tables: Selecting Items In Lesson 2:F, you defined IMAGE tables PRODUCT-MASTER and INVENTORY from datasets in database SAMPL2. You included all dataset items in each table. For the view tables you'll define later in this lesson, you need items from two datasets in database SAMPL1--datasets SALES-STAFF and ORDER-DETAIL. Now define IMAGE tables derived from these datasets, including only the items you need. The system will look like this:Figure 5-2. IMAGE Tables SALES-STAFF and ORDER-DETAIL Added ___________________________________________________________ | | | References in this Learning manual: | | Before You Begin: | | Description of Sample Databases | | Lesson 1:D, How the Data Dictionary is Configured| | Lesson 2:F, Configuring IMAGE Tables | | Appendix A, Schema for SAMPL1 Database | | | | References in Information Access Server: Database | | Administration: | | Chapter 5, Configuring Tables: | | Adding an IMAGE Table Definition | ___________________________________________________________ Finding the Right DatasetGo to screen AIMT --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | B-1. Type AIMT Enter. | The Add IMAGE Table (AIMT) screen appears. | | | `R` | | | | | Here you'll learn several ways to define | | | IMAGE tables that include selected dataset | | | items, rather than the entire dataset. | | | | | | The datasets you want are in database | | | SAMPL1, which you just configured. | | | | | | B-2. In the Database field, type SAMPL1 | This name uniquely identifies the database | | and press Enter. | as SAMPL1 on the host HP 3000. The | | | Administrator Utility finds the database | | | definition in the data dictionary. | | | | | | Additional fields appear so you can specify | | | a dataset from which to derive the table. | | | | --------------------------------------------------------------------------------------------- | | | | CUSTOMER-MASTER, the first of SAMPL1's | | | three datasets, is the default name in the | | | Dataset and Table fields. You don't want | | | this default dataset. | | | | | | B-3. To cycle through the datasets until a | The second dataset name, SALES-STAFF, | | name you want is displayed, choose: | appears in the Dataset and Table fields. | | | | | Next f3 | | | Dataset | | | | | --------------------------------------------------------------------------------------------- | | | | SALES-STAFF is one of the datasets you | | | want. | | | | | | B-4. Fill in the Table Description field | Additional fields appear so you can choose | | (if you want) and press Enter. | which items to include in the IMAGE table. | | | | --------------------------------------------------------------------------------------------- Method 1: Eliminating Unwanted Items --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | You only need three of the dataset | | | SALES-STAFF's items for the view table you | | | plan to define later. | | | | | | One way to select them is to use function | | | keys to get and include all the items in | | | the dataset (as in Lesson 2:F), then | | | manually eliminate the ones you don't want. | | | | | | B-5. Choose: | The Administrator Utility retrieves the | | | names of all the items in this dataset. | | Get f1 | | | Items | | | | | | B-6. To include them all, choose: | A number automatically appears in each | | | item's Order field. | | Order & f4 | | | Incl All | | | | | --------------------------------------------------------------------------------------------- | | | | You need SALES-REP, EMP-NBR, and OFFICE for | | | view tables you'll define later in this | | | lesson. | | | | | | Eliminate the unwanted items by blanking | | | out their Order fields. | | | | | | B-7. Replace the number in the Order | Numbers should remain only in the Order | | fields for PHONE and SALES with a blank | fields for SALES-REP, EMP-NBR, and OFFICE. | | character. | The numbers do not have to be contiguous. | | | | | B-8. Press Enter. | Since these items are type character, they | | | do not need data conversion. Pressing | | | Enter adds the definition of the IMAGE | | | table SALES-STAFF to the data dictionary. | | | | | | The Add IMAGE Table screen reappears. | | | | | | Only the three dataset items with filled-in | | | Order fields are defined as items in the | | | table. By default, the table name is the | | | dataset name. | | | | --------------------------------------------------------------------------------------------- Method 2: Picking Items to Include --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | The dataset ORDER-DETAIL is now the default | (If you examine the SAMPL1 schema in | | in the Dataset and Table fields. | Appendix A, you'll notice that the dataset | | | DATE-MASTER is skipped because it is an | | ORDER-DETAIL is one of the datasets you | automatic master dataset.) | | want. | | | | | | B-9. Type a description in the Table | The item fields appear. | | Description field (if you want) and press | | | Enter. | | | | | --------------------------------------------------------------------------------------------- | | | | You want four of the eight items in the | | | dataset ORDER-DETAIL. | | | | | | This time, after you get all the items, | | | pick the four items you want in the table | | | instead of eliminating those you don't | | | need. | | | | | | B-10. Choose: | The names of all the items in this dataset | | | appear. | | Get f1 | | | Items | | | | | --------------------------------------------------------------------------------------------- | | | | Pick the items you want to include in the | | | table by filling in their Order fields. | | | | | | B-11. Type 1 in the Order field for | Only the four items with filled-in Order | | EMP-NBR, 2 for PRODUCT-NBR, 3 for | fields will be included in the table. | | ORDER-DATE, and 4 for ORDER-QTY. Press | | | Enter. | The Administrator Utility detects one item | | | that needs conversion and displays the | | | IMAGE Data Conversion screen. | | | | --------------------------------------------------------------------------------------------- | | | | B-12. Press Enter to accept the default | The definition of the IMAGE table | | conversion values for ORDER-QTY. | ORDER-DETAIL is added to the data | | | dictionary. | | | | | | The four dataset items with filled-in Order | | | fields are defined as items in the table. | | | By default, the table name is identical to | | | the dataset name. When data is retrieved | | | from the dataset ORDER-DETAIL, packed | | | decimal items will be converted to real | | | numbers with no decimal digits. | | | | --------------------------------------------------------------------------------------------- Table 5-0. (cont.) --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | You're done defining IMAGE tables. Now, | | | you're ready to define view tables. | | | | | | B-13. Choose: | The Add IMAGE Table screen appears. | | | | | Done f8 | | | | | | B-14. Choose: | The Add Table Menu appears. From here you | | | can easily proceed to adding view tables. | | Done f8 | | | | | --------------------------------------------------------------------------------------------- Method 3: Filling in Known Items A third way to select items for an IMAGE table is to type in the Item names and their Order yourself, without using any function labels. To use this method you need a printed reference, such as the database schemas in Appendixes A and B, to make sure you enter each item accurately. Summary In this exercise, you learned three different methods for selecting which dataset items to include in an IMAGE table: * Use function labels to get and include all items in the dataset, then eliminate unwanted items by blanking out their Order fields. * Use a function label to get all items in the dataset, then pick each item you want by typing a number in its Order field. * Type in Item names and Order numbers by referencing a printed listing of the database schema, without using function labels. When you configure IMAGE tables of your own, use the method that best suits the situation. For example, you might want to use the first method for a table that includes most of the items in a dataset, and the second method for a table that includes only a few.
![[]](../../pic3k/M012040/FFN583c50.gif)
![[]](../../pic3k/M012040/FFN603c50.gif)