Commands and Syntax › DELETE TABLE—OLQ access mode

DELETE TABLE—OLQ access mode

DELETE TABLE allows you to delete ASF tables provided you hold the appropriate passkeys.

Access mode: The syntax below is invalid when the access switch is set to IDMS.

Syntax:

►►─── DELete TABle ─┬─────┬─ asf-table-name ──────────────────────────────────►
                    └─ = ─┘

 ►─┬─────────────────────────────┬────────────────────────────────────────────►
   └─ OWNer ─┬─────┬─ user-name ─┘
             └─ = ─┘

 ►─┬─────────────────────────────────────┬────────────────────────────────────►
   └─ CATalog ─┬─────┬─ dictionary-name ─┘
               └─ = ─┘

 ►─┬──────────────────────────────────────┬───────────────────────────────────►◄
   └─ LOCation ─┬─────┬─ dictionary-node ─┘
                └─ = ─┘

Parameters:

asf-table-name

Specifies the ASF table to be deleted

OWNER= user-name

Specifies the user ID of the owner of the ASF table. If user-name isn't specified, the default is the current user ID.

CATALOG= dictionary-name

Specifies the dictionary containing the catalog entry for the named ASF table.

LOCATION= dictionary-node

Specifies the DDS node controlling the catalog.

Example:

In this example, the table definition and associated occurrences for the EMP-HOSPITAL table are deleted:

delete table=emp-hospital owner=bdm catalog=asfdict

 OLQ 116006   TABLE DEFINITION EMP-HOSPITAL SUCCESSFULLY DELETED