Online Commands › DELETE › In DBMAINT and FILEMAINT Modes

In DBMAINT and FILEMAINT Modes

Use the DELETE command to remove a structure at the root level or a substructure at the base level in DBMAINT and FILEMAINT Modes. This function is valid for all structures and substructures. Results of this command vary depending on the status of the structure or substructure.

• In TEST or HIST status, this function deletes the structure or substructure from CA Datacom Datadictionary.
• In PROD status, this function moves the structure or substructure to HIST status and assigns a version number. CA Datacom Datadictionary increments the previous HIST status version by 1 and assigns that to the subject structure or substructure.

With the proper authorization, you can delete a structure or substructure in HIST status. However, when the maximum number of allowed HIST status versions is reached, CA Datacom Datadictionary automatically deletes the structure or substructure with the oldest date/time stamp. The maximum number of HIST status versions is specified in the ENTY-HIST-VERS attribute of the TABLE occurrence for the entity in the DATA-DICT database. For more information about this attribute, see OBSOLETE and the section about TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Note: Use the SQL DROP statement to delete SQL accessible tables, views, or synonyms. For more information, see the CA Datacom/DB SQL User Guide.

If your completed command exceeds the 76 spaces available in one command line, use the prompter panel to issue the command.

Use the following format for this command:

DELETE (in DBMAINT and FILEMAINT modes)

►►─┬─ DELETE ─┬─ entity ─ occ-name ─┬─ STATUS xxxx ─┬─────────────────────────►
   └─ DEL ────┘                     └─ STA xxxx ────┘

 ►─┬─────────────────┬─┬─────────────────┬────────────────────────────────────►◄
   ├─ PASSWORD xxxx ─┤ ├─ OVERRIDE xxxx ─┤
   └─ PSWD xxxx ─────┘ └─ OVRD xxxx ─────┘

entity

(Required) Specify the entity for the occurrence you are deleting.

Valid Entries in DBMAINT Mode:

DATABASE|BAS AREA|ARA

TABLE|TBL

KEY

ELEMENT|ELM

DATAVIEW|DVW

Valid Entries in FILEMAINT Mode:

FILE|FIL RECORD|REC

KEY

ELEMENT|ELM

DATAVIEW|DVW

Default Value:

(No default)

occ-name

(Required) Specify the occurrence name of the occurrence you are deleting.

Valid Entries:

1- to 32-character occurrence name

Default Value:

(No default)

STA xxxx

(Required) Specify the status of the occurrence you are deleting.

Valid Entries:

T001—T999
PROD
QUAL (valid for TBL, KEY, ELM)

Default Value:

(No default)

PSWD xxxx

Only required if this occurrence has password protection against unauthorized maintenance. Supply the password for this occurrence.

Valid Entries:

1- to 4-character password

Default Value:

(No default)

OVRD xxxx

Only required if this occurrence is restricted from unauthorized maintenance or retrieval with a lock level assignment. Supply the override code.

Valid Entries:

1- to 4-character override code

Default Value:

(No default)

When you press PF9 (APPLY), CA Datacom Datadictionary responds with a message confirming successful completion of the function on the menu for the selected mode.