In QBE, you create queries in an example table. An example table is a framework in which you enter instructions about how you want data presented in your report. (If you have the appropriate authorization, you can also use keywords (D. I. and U.) in an example table to make changes to a database.) For example, from a RESET QBE QUERY panel, the Q.ORG example table displays when you issue the command:
DRAW Q.ORG
Q.ORG | DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION |
------+----------+-------------+---------+----------+------------|
| | | | | |
|
Within this framework, you can select the columns you want presented with P., and use other QBE keywords to control the presentation of the report data and make changes to the database.
The program function keys shown at the bottom
of the screen make it easier to perform certain functions. Your installation may have changed the setting of the function keys. This book uses the initial settings: