Building and Using Data Tables › Modifying Data Tables › Demonstration (3): Deleting a Table

Demonstration (3): Deleting a Table

Objective

This example deletes the definition and data of a table containing old customer information.

IN 80

IN 80 is used to meet the CA Culprit INPUT parameter requirement.

05OUTPUT TABLE=OLD- CUSTOMERS
TYPE=DELETE  USER=DOC1 PW=DOC1
         CATALOG=ASFDICT

OUTPUT identifies the OUTPUT parameter, which includes the DELETE instruction.

TABLE=OLD-CUSTOMERS names the table to be deleted.

TYPE=DELETE specifies deleting the table.

0551*001 ' '

5 specifies a type 5 parameter, which is used to meet CA Culprit's coding requirements.

057001 DROP

DROP on the type 7 parameter stops unnecessary input processing.

Complete Code

 col. 2
 ▼
 IN 80
 REC INFIELD  1  80
 05OUTPUT TABLE=OLD-CUSTOMERS TYPE=DELETE USER=DOC1 PW=DOC1
*       CATALOG=ASFDICT
 0551*001 ' '
 057001   DROP

Results

mm/dd/yy              RUN TIME MESSAGE0        volser Vnn.n  PAGE     1

***********  END OF FILE  ******************************************************
           7 INPUT RECORDS READ
      DATA TABLE UPDATE STATISTICS
                                                               TABLE            ROWS
       REPORT     FUNCTION         LR-NAME                  DEFINITION         STORED
       ──────     ────────         ───────                  ──────────         ──────
        05        DEL        OLD-CUSTOMERS              DELETED                    0