Catalog a DATABASE Structure

DBMAINT Mode - DATACOM/DB Structure Maintenance › Catalog a DATABASE Structure

Catalog a DATABASE Structure

Use the CATALOG function to post the definition of an entire DATABASE structure to the CA Datacom/DB Directory (CXX). The structure can be in TEST or PROD status. The database must be closed in the CA Datacom/DB Directory before the CATALOG can successfully process.

To replicate a database accessible by SQL, see Copy Structures.

Note: The CATALOG function is not available in the version of CA Datacom Datadictionary supplied with CA Datacom/AD. For more information, see the documentation for the CA application product using CA Datacom/AD.

How to Use

Use one of the following procedures to perform this function:

Select the CATALOG option on the DB Structure Functions Menu and fill in the following prompter panel.
Use the CATALOG command.
Type the CAT margin command in the line number of the DATABASE on an indented structure or an index display, enter the PROCESS command (press PF4) to obtain a filled in CATALOG prompter panel, and press PF9 (APPLY).

 =>
 =>
 =>
 1-DDOL000196A - CMPP - PLEASE COMPLETE REQUIRED INFORMATION FOR COMMAND
 -------------------------------------------------------------------------------
 DATACOM/DB Structure Maintenance                                           TXCF

 CATALOG  DATABASE ________________________________ in STATUS ____
 CAT      BAS      (name)                              STAT  (stat)


 with PASSWORD      using OVERRIDE
      PSWD    (pswd)      OVRD    (ovrd)









 PF1=HELP  PF2=END  PF3=CLARIFY  PF4=PROCESS  PF5=MENU   PF6=STATUS
 PF7=SCB   PF8=SCF  PF9=APPLY    PF10=PATH    PF11=NEXT  PF12=INPUT

The following list describes each field, the valid entries and the default (if one exists). Fields that require an entry are highlighted on your terminal. Fields which are not highlighted indicate that an entry is optional.

(name)

(Required) Specify the DATABASE occurrence name.

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

(stat)

(Required) Specify the status or version of the DATABASE occurrence.

Valid Entries:: T001—T999
PROD
001—999 (the version number of the DATABASE structure that is in PROD status)
Default Value:: (No default)

(pswd)

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

Valid Entries:: 1- to 4-character password
Default Value:: (No default)

(ovrd)

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) after completing your entries.

If the CATALOG function is successful and no errors are detected, CA Datacom Datadictionary displays the DATACOM/DB Structure Select Panel with a message indicating successful completion of this function.
If the CATALOG function is successful but warning errors are detected, CA Datacom Datadictionary displays a message indicating successful completion of the CATALOG and a list of warnings regarding questionable structural choices.
After a CATALOG, to get an Impact Report that shows you the impact of the CATALOG see the information about the CXX Report TYPE=I in the CA Datacom/DB DBUTLTY Reference Guide.
If the CATALOG function fails due to errors, CA Datacom Datadictionary displays a message that the function was not completed successfully and a list of error messages describing the reasons the function failed.