HP 3000 Manuals HP 3000 Manuals
Phase H. Configuring View Tables Now that all of the IMAGE and file tables your PC users need are configured, you are ready to configure view tables. View tables are derived from one to 16 previously configured tables (IMAGE, file, or view). They can contain as many as 64 items (columns). Both the primary and secondary DBAs can configure view tables, but a secondary DBA must control all the tables from which the view table configured is derived. Adding View Tables --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | H-1. Type AVT in the Go to screen field | The Add View Table (AVT) screen appears. | | and press Enter. | | | | | --------------------------------------------------------------------------------------------- | | | | H-2. Type a view table definition, using | The view table definition is added to the | | Next Fields f4 to display the second group | data dictionary and the first group of Add | | of Add View Table fields, and press Enter. | View Table fields returns. | | | | --------------------------------------------------------------------------------------------- | | | | H-3. Repeat Step H-2 for each view table | The Administrator Utility adds the | | you want to configure. | definition of each view table to the data | | | dictionary. | | | | --------------------------------------------------------------------------------------------- | | | | H-4. Choose Done f8. | The Add Table Menu appears. | | | | | Choose Done f8 again. | The Table Menu appears. | | | | | If you don't want to check your | | | configuration of view tables, skip to Phase | | | I. | | | | | --------------------------------------------------------------------------------------------- Checking Configuration --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | H-5. Choose List All Tables f5. | The List Tables Menu appears. | | | | | Choose View Tables f2. | The List View Tables screen appears. This | | | screen lists the names of all configured | | | view tables. | | | | | | Secondary DBAs will see only the names of | | | the view tables under their control. | | | | - - | | | | Check to see that all your view tables are | | | configured. If any view tables need to be | | | added, use the Add View Table (AVT) screen | | | to do so. If any view tables are not | | | defined correctly, use the Change Table | | | (CT) screens to correct the definition. | | | | | --------------------------------------------------------------------------------------------- | | | | H-6. Choose Done f8. | The List Tables Menu appears. | | | | ---------------------------------------------------------------------------------------------