OBSOLETE

Use the OBSOLETE command to remove a structure or substructure in all existing statuses from CA Datacom Datadictionary. It is valid only for CA Datacom/DB and CA FILE Model structures and substructures. This function has a greater impact than deleting each of the occurrences in the structure or substructure individually in each status.

When you use this function, you are stating that you no longer require this structure or substructure in CA Datacom Datadictionary. The OBSOLETE command causes all references to the occurrences in the specified structure or substructure to be removed from CA Datacom Datadictionary, including relationships.

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.

Caution: Due to the impact of the OBSOLETE function, we recommend that the authorization to use this function be restricted. See the person responsible for security administration on your system for information about restricting the use of functions.

Use the following format for this command:

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

►►─┬─ OBSOLETE ─┬─ entity1 ─ occ-name ────────────────────────────────────────►
   └─ OBS ──────┘

 ►─┬────────────────────────────────┬─┬─────────────────┬─────────────────────►
   └─┬──────┬─ entity2 ─ occ-name2 ─┘ ├─ PASSWORD xxxx ─┤
     └─ OF ─┘                         └─ PSWD xxxx ─────┘

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

entity1

(Required) Specify the entity of the base of the structure or the root of the substructure you are removing.

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-name1

(Required) Specify the name of the base of the structure or the root of the substructure you are removing.

Valid Entries:: 1- to 32-character occurrence name
Default Value:: (No default)

entity2

Only required if you are removing a KEY or ELEMENT substructure. Specify one of the following entities:

Valid Entries in DBMAINT Mode:: TABLE|TBL
Valid Entries in FILEMAINT Mode:: RECORD|REC
Default Value:: (No default)

occ-name2

Only required if you are removing a KEY or ELEMENT substructure. Specify the name of the TABLE or RECORD occurrence containing the subject KEY or ELEMENT substructure.

Valid Entries:: 1- to 32-character occurrence name
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)

Press PF9 (APPLY) to complete this function. CA Datacom Datadictionary responds with a message confirming successful completion of the function.