When you display a report by using the default report format, QMF assigns each column a name. Usually, this name is the column name or label from the table where you retrieve the data. Each column that you define in a query is given the name COL or EXPRESSION followed by a number so that each column name is unique. If you are using DB2 for AIX, QMF identifies columns you define by only a number.
You can change column headings on the FORM.COLUMNS panel.
In this example, change the headings for the NAME, DEPT, and COMM columns.
To change column headings:
For this example, type:
FORM.COLUMNS MODIFIED Total Width of Report Columns: 62 NUM COLUMN HEADING USAGE INDENT WIDTH EDIT SEQ --- ---------------------------------------- ------- ------ ----- ----- --- 1 EMPLOYEE_NAME 2 9 C 3 2 DEPT._NUMBER 2 6 L 1 3 JOB 2 5 C 2 4 SALARY 2 10 L2 4 5 COMMISSIONS 2 10 L2 5 6 TOTAL_EARNINGS 2 10 C 6 *** END ***
DEPT. EMPLOYEE TOTAL NUMBER JOB NAME SALARY COMMISSION EARNINGS ------ ----- --------- ---------- ---------- ---------- 15 CLERK KERMISCH 12258.50 110.10 12368.60 15 CLERK NGAN 12508.20 206.60 12714.80 15 SALES ROTHMAN 16502.83 1152.00 17654.83 20 CLERK JAMES 13504.60 128.20 13632.80 20 SALES PERNAL 18171.25 612.45 18783.70 20 CLERK SNEIDER 14252.75 126.50 14379.25 38 CLERK ABRAHAMS 12009.75 236.50 12246.25 38 CLERK NAUGHTON 12954.75 180.00 13134.75 38 SALES O'BRIEN 18006.00 846.55 18852.55 38 SALES QUIGLEY 16808.30 650.25 17458.55