Previous Topic: DEFINE PATHNext Topic: DELETE QFILE

Commands and Syntax › DELETE COMPUTATION

DELETE COMPUTATION

DELETE COMPUTATION deletes the named computed fields from the report.

Syntax:

                            ┌────────────────┐
►►─── DELete COMputation ─┬─▼- compute-name ─┴─┬──────────────────────────────►◄
                          └─ ALL ──────────────┘

Parameters:

compute-name

Specifies the name of the computed field to be deleted.

ALL

Specifies that all computed fields be deleted.

Example:

This example operates on the report created and modified by the following SELECT and COMPUTE statements:

select emp-id-0415, salary-amount-0420
 from employee, emposition where emp-emposition !
compute 'average salary' = avg(salary-amount-0420) group by all !
display

EMP-ID-0415    SALARY-AMOUNT-0420

       1204                 25000
       1140                 23000
       0145                 35000
       0532                 30000
                      ===========
            AVERAGE SALARY: 28250

To delete the computed field AVERAGE SALARY:

delete computation 'average salary' ! display

EMP-ID-0415    SALARY-AMOUNT-0420

       1204                 25000
       1140                 23000
       0145                 35000
       0532                 30000