HP 3000 Manuals HP 3000 Manuals
Phase F. Configuring IMAGE Tables In Phase D you configured your IMAGE databases. Now you can configure IMAGE tables from them. An IMAGE table is derived from one IMAGE dataset and can contain as many as 64 items (columns). When Access Server is installed, an IMAGE table called JOB-STATUS is automatically configured from the JOB-STATUS dataset of the HDPENV database to help your users track the progress of jobs they launch using the Host Batch Facility. For details, see the discussion at the end of Chapter 13, "Batch Processing with Command Files," in the Information Access Server: Database Administration manual.
NOTE For users of the OMNIDEX Information Management System, IMSAM composite keys appear in the Show IMAGE Table screens. For more information, see the OMNIDEX Information Management System Reference Manual and "IMSAM Composite Keys" in Appendix B of the Information Access Server: Database Administration manual.
Adding IMAGE Tables --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | F-1. Type AIMT in the Go to screen field | The Add IMAGE Table (AIMT) screen appears. | | and press Enter. | | | | | --------------------------------------------------------------------------------------------- | | | | F-2. Type as much information as will | Additional Add IMAGE Table fields appear, | | uniquely identify the database from which | with the name of the first dataset in the | | you want to derive an IMAGE table, then | database highlighted. | | press Enter. | | | | | --------------------------------------------------------------------------------------------- | | | | F-3. Use Previous Dataset f2 and Next | More Add IMAGE Table fields appear. | | Dataset f3 to find the dataset you want, or | | | type a dataset name in the Dataset field. | | | Modify the table name and description as | | | desired, then press Enter. | | | | | --------------------------------------------------------------------------------------------- | | | | F-4. Either press Enter to include all | If no items are of type zoned decimal (Z), | | items in the IMAGE table; or choose Get | packed decimal (P), or integer (I), the | | Items f1, specify the items and their | table definition is added and the next | | order, and press Enter. | dataset name appears. | | | | | (For datasets with more than 64 items, | Otherwise, fill in the Conversion screen | | you'll need to limit the number you include | that appears, and press Enter to add the | | in the IMAGE table.) | table definition. | | | | --------------------------------------------------------------------------------------------- Table 2-0. (cont.) --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | F-5. Repeat Steps F-3 and F-4 for each | The definition of each IMAGE table is added | | IMAGE table you want to configure from the | to the data dictionary. | | same IMAGE database. | | | | | --------------------------------------------------------------------------------------------- | | | | F-6. Choose Done f8. | The Add Table Menu appears. | | | | --------------------------------------------------------------------------------------------- | | | | F-7. Repeat Steps F-1 through F-6 for each | The Administrator Utility adds the | | additional database from which you want to | definition of each IMAGE table to the data | | configure IMAGE tables. (Instead of typing | dictionary. | | AIMT in Step F-1, you can choose IMAGE | | | Table f2 at the Add Table Menu to display | | | the first group of Add IMAGE Table fields.) | | | | | --------------------------------------------------------------------------------------------- | | | | F-8. Choose Done f8. | The Table Menu appears. | | | | | If you don't want to check your | | | configuration of IMAGE tables, skip to | | | Phase G. | | | | | --------------------------------------------------------------------------------------------- Checking Configuration --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | F-9. Choose List All Tables f5. | The List Tables Menu appears. | | | | | Choose IMAGE Tables f3 to go to the List | The List IMAGE Tables screen appears. This | | IMAGE Tables screen. | screen lists the names of all configured | | | IMAGE tables. | | | | | | Secondary DBAs will see only the names of | | | the IMAGE tables under their control. | | | | | Check to see that all your IMAGE tables are | | | configured. If any IMAGE tables need to be | | | added, use the Add IMAGE Table (AIMT) | | | screen to do so. If any IMAGE tables are | | | not defined correctly, use the Change Table | | | (CT) screens to correct the definition. | | | | | --------------------------------------------------------------------------------------------- | | | | F-10. Choose Done f8. | The List Tables Menu appears. | | | | ---------------------------------------------------------------------------------------------