G : Configuring a View Table [ Information Access Server: Learning the Administrator Utility ] MPE/iX 5.0 Documentation
Information Access Server: Learning the Administrator Utility
G : Configuring a View Table
Now configure a simple view table--PRODUCTS. You'll use the data in
Worksheet 3, Figure 2-4. (You'll be using Worksheet 2 in the next
exercise, 2:H.)
This table renames the items in the IMAGE table PRODUCT-MASTER so PC
users can load them into dBASE II.
Here's what the system will look like when you add this view table:
Click here to view figure.
Figure 2-8. View Table PRODUCTS Renames IMAGE Items
___________________________________________________________
| |
| References in this Learning manual: |
| Lesson 1:D, How the Data Dictionary is Configured|
| Figure 2-4, Worksheet 3 Completed |
| |
| References in Information Access Server: Database |
| Administration: |
| Chapter 5, Configuring Tables: |
| Adding a View Table Definition |
| Appendix B, Constructing View Tables |
| Appendix C, View Table Syntax |
___________________________________________________________
Which Items?
Click here to view figure.
---------------------------------------------------------------------------------------------
| | |
| What You Do | What Happens |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-1. At the Add Table Menu, choose: | The Add View Table screen appears. |
| | |
| View f1 | Each field on these screens has its |
| Table | required syntax. (You'll find the syntax |
| | in Chapter 5 and Appendix C of the |
| | Information Access Server: Database |
| | Administration manual.) |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-2. Type the text shown on the next page | |
| in the fields indicated. | |
| | |
| The Item Clause field is being used to | |
| rename IMAGE items to eight characters or | |
| less for use with dBASE II on the PC. | |
| | |
| In the Item Clause field, you can type the | |
| items in a continuous string if you like, | |
| and text will automatically wrap around. | |
| | |
| However, it's easiest to correct typing | |
| mistakes when you list the items as shown, | |
| one item per line. To use a new line, type | |
| Return, then v. | |
| | |
| Be sure to separate items with commas. | |
| | |
---------------------------------------------------------------------------------------------
________________________________________________________________________________________
| |
| |
| Table PRODUCTS Sample Values Security |
| |
| Table Description PRODUCT VIEW TABLE |
| |
| Item Clause (separated by commas) |
| NUMBER = PRODUCT-NBR, |
| PRODUCT = PROD-DESCRIPT, |
| VENDOR = VENDOR-NAME, |
| TYPE = PRODUCT-TYPE, |
| UNITCOST = UNIT-COST, |
| PRICE, |
| NOTES = PROD-NOTES |
| |
| |
| |
| |
| |
| |
| |
| |
| |
________________________________________________________________________________________
---------------------------------------------------------------------------------------------
| | |
| G-3. Proofread the information you've | As was true for IMAGE tables, when view |
| typed and when you're sure it's correct, | tables are defined, more fields are |
| choose: | required than will fit on one screen |
| | display. When you choose Next Fields f3, |
| Next f3 | additional fields appear. |
| Fields | |
| | |
---------------------------------------------------------------------------------------------
Using What Table as Source?
---------------------------------------------------------------------------------------------
| | |
| What You Do | What Happens |
| | |
---------------------------------------------------------------------------------------------
| | |
| Indicate what previously configured | |
| table(s) to use as the source of the item | |
| just defined. | |
| | |
| G-4. Type PRODUCT-MASTER in the Using | This tells the Administrator Utility to |
| Clause field. | look in the table PRODUCT-MASTER to find |
| | the items. The Using Clause must always be |
| | filled in so Access Server will know where |
| | to go when it constructs this view table. |
| | |
| You could also define operators to limit | |
| which records to include (the Where Clause) | |
| and a sort order for the records (the Sort | |
| Clause). | |
| | |
| However, because you want to include all | |
| records in their default order, the Using | |
| Clause is all you need. | |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-5. To configure the view table, press | The screen clears and displays the first |
| Enter. | group of Add View Table fields. Your entry |
| | has been accepted. |
| (If you made a syntax error when typing in | |
| the Item Clause, an error message appears | You have told the Administrator Utility to |
| and the cursor goes to the field with the | draw the items you specified from all |
| error. Correct your mistake and press | records included in the table |
| Enter.) | PRODUCT-MASTER, in default order. The |
| | items will be renamed for use with dBASE |
| | II. |
| | |
---------------------------------------------------------------------------------------------
| | |
| G-6. To get ready for the next task, | The Add Table Menu appears. You have |
| return to the previous menu by choosing: | successfully added a simple view table. |
| | (You'll define a complex table in Lesson |
| Cancel f8 | 5.) |
| Add | |
| | You are in position to go directly into the |
| | next task by using the Go to screen field. |
| | |
---------------------------------------------------------------------------------------------
What This Table Will Look Like
Here is what the view table PRODUCTS will look like when it is displayed
using Access PC:
Click here to view figure.
Click here to view figure.
Figure 2-9. PC Display of View Table PRODUCTS
Summary
In this exercise, you learned how to:
* Specify view table items that derive from one IMAGE table.
* Rename IMAGE items for use with dBASE II on a PC.
MPE/iX 5.0 Documentation
HP 3000 Manuals