Previous Topic: Define Keys and Elements to the TableNext Topic: Add Areas to the Database


Create DATABASE Structures

Use the CREATE function to define a root occurrence for a structure. In the DBMAINT Mode, there are only two structures, DATABASE and DATAVIEW. The root of a DATABASE structure is a DATABASE occurrence. The root of a DATAVIEW structure is a DATAVIEW occurrence. Use the ADD function to define the base occurrence of a substructure, such as an AREA occurrence for an AREA substructure.

How to Use

You can define a DATABASE occurrence by using one of the following procedures:

When you select the CREATE function on the DB Structure Functions Panel, you receive the following prompter panel:

=> => => 1-DDOL000196A - CMPP - PLEASE COMPLETE REQUIRED INFORMATION FOR COMMAND ----------------------------------------------------------------------------- DATACOM/DB Structure Maintenance TCCF CREATE DATABASE ________________________________ in STATUS ____ CRE BAS (name) STAT (status) with PASSWORD using LOCK 0 LIKE ________________________________ PSWD (pswd) LOC (lock) LIKE (name) 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 name of the DATABASE occurrence you are defining.

Valid Entries:

1- to 32-character name

Default Value:

(No default)

(status)

(Required) Specify the status for the new occurrence.

Valid Entries:

T001—T999

Default Value:

(No default)

(pswd)

(Optional) Specify a password to protect this occurrence from unauthorized updates. For more information, see the section about protecting definitions in the CA Datacom Datadictionary User Guide.

Valid Entries:

1 to 4 alphanumeric characters

Default Value:

(No default)

(lock)

(Optional) Specify a lock level to restrict access to this occurrence. For more information, see the section about protecting definitions in the CA Datacom Datadictionary User Guide.

Valid Entries:

0, 1, or 2

Default Value:

0

LIKE (name)

(Optional) Specify the name of an existing DATABASE occurrence in the same status to use as the model for the occurrence you are creating.

Note: Any aliases or descriptors assigned to the existing occurrence are not duplicated for the new occurrence. Define these separately.

Valid Entries:

1- to 32-character name

Default Value:

(No default)

When you press Enter, the DATABASE definition panel appears.

=> => => ----------------------------------------------------------------------------- DATACOM/DB STRUCTURE MAINTENANCE CREATE TUDU ............................ DATABASE ATTRIBUTES ............................ Name: ORDER-ENTRY Status/Version: T001 Database ID: _____ .............................. AREA ATTRIBUTES .............................. Name DB-NM Blk Sp-Mgt Slack Pswd Lock ====== ============ T O P ============= === ===== = ==== ==== = 000001 ________________________________ ___ _____ _ ____ _ ====== ========= B O T T O M ========== === ===== = ==== ==== = 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 DATABASE definition panel displays a DATABASE ATTRIBUTES region and an AREA ATTRIBUTES region. You can enter only one attribute-value for the DATABASE occurrence on this panel.

Database ID

(Required) Specify a unique five-digit database identification number (DATACOM-ID). Database IDs 1 through 20 are reserved for CA.

For more information and a description of the reserved database IDs, see the CA Datacom/DB Database and System Administration Guide.

Valid Entries:

00001—05000