Drawing example tables

In QBE, you create queries in an example table.

Db2® for z/OS® Version 13 Release 1 increases maximum column name lengths from 30 bytes to 128 bytes. Db2 for z/OS Version 13 Release 1 increase to 128 byte column name support is limited for those applications that use an SQLDA to obtain column name information. The QMF for TSO and CICS application falls into this category. Due to this Db2 for z/OS limitation, column names longer than 30 bytes are truncated. If a column name longer than 30 bytes is present, the QBE command is blocked from usage.

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 the 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 following command:

DRAW Q.ORG

The example table appears as shown in the following figure:

Figure 1. A QBE example table drawn for the Q.ORG table

Q.ORG | DEPTNUMB | DEPTNAME    | MANAGER | DIVISION | LOCATION   |
------+----------+-------------+---------+----------+------------|
      |          |             |         |          |            |

Within this framework, you can select the columns you want to see by using the P. keyword and 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 site may have changed the setting of the function keys. The initial default settings are as follows:

1: Shows help information about your last action.
2: Runs your query.
3: Returns to the QMF home panel.
4: Makes the object larger.
5: Makes the object smaller.
6: Draws an empty example table.
7: Moves the display backward.
8: Moves the display forward.
9: Shows the form panel last used.
10: Scrolls the display to the left.
11: Scrolls the display to the right.
12: Displays your report.