Previous Topic: Copying the Report ModuleNext Topic: Changing Headings


Deleting Columns

DROP Clause of the USE Parameter

The following code deletes the SCHEMA, VER, and SUBSCHEMA columns shown in the sample report above. Each character string begins with 5, which designates an edit parameter for detail lines. The 1 that follows designates the edit line number. The remaining four numbers designate the absolute column position for each field.

DROP '510001' AND    $DROP SCHEMA
     '510009' AND    $DROP VER
     '510016'        $DROP SUBSCHEMA

The following figure shows DREPORT 038 modified by this code:

REPORT NO. 28 DATA DICTIONARY REPORTER mm/dd/yy PAGE 1 DREPORT 028 IDMS RECORD ACTIVITY REPORT ********************************************************************************************************************************* ---- D A T E ---- SCHEMA VER SUBSCHEMA RECORD PROGRAM VER USAGE TIMES COMPILED CREATED ********************************************************************************************************************************* COVERAGE EMPINQ 1 BIND 1 mm/dd/yy mm/dd/yy DENTAL-CLAIM EMPINQ 1 BIND 1 mm/dd/yy mm/dd/yy DEPARTMENT D3 1 BIND 1 mm/dd/yy mm/dd/yy DEPARTMENT D4 1 BIND 1 mm/dd/yy mm/dd/yy DEPARTMENT D6 1 BIND 1 mm/dd/yy mm/dd/yy DEPARTMENT D6 1 OBTAIN 1 mm/dd/yy mm/dd/yy DEPARTMENT EMPINQ 1 BIND 1 mm/dd/yy mm/dd/yy DEPARTMENT TESTPROG 1 BIND 1 mm/dd/yy DEPARTMENT TESTPROG 1 OBTAIN 2 mm/dd/yy EMPLOYEE D3 1 BIND 1 mm/dd/yy mm/dd/yy EMPLOYEE D3 1 FIND 1 mm/dd/yy mm/dd/yy