Add AREA Substructures

DBMAINT Mode - DATACOM/DB Structure Maintenance › Add Structures › Add AREA Substructures

Add AREA Substructures

Use the ADD AREA function to define the base occurrence of an AREA substructure. CA Datacom Datadictionary automatically relates the AREA occurrence to the existing DATABASE occurrence that you specify.

How to Use

Use one of the following procedures to perform this function:

Select the ADD option on the AREA Structure Functions Menu, fill in the following prompter panel and complete the AREA definition panel.
Use an ADD command (see ADD) for an AREA and complete the AREA definition panel.
Type the MOD margin command in the line number of a DATABASE on an indented structure display. Retrieve the DATABASE with PF4 (PROCESS) and complete an entry for an AREA in the AREA section on the DATABASE definition panel.

When you select the ADD option on the AREA Structure Functions Panel, you receive the following prompter panel:

 =>
 =>
 =>
 1-DDOL000196A - CMPP - PLEASE COMPLETE REQUIRED INFORMATION FOR COMMAND
-----------------------------------------------------------------------------
 DATACOM/DB Structure Maintenance
                                                                         TACF
 ADD AREA     ________________________________
 ADD ARA      (name)

 TO  DATABASE ________________________________ in STATUS ____
 TO  BAS      (name)                              STA    (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

AREA (name)

(Required) Specify the name for the occurrence you are adding.

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

DATABASE (name)

(Required) Supply the name of the existing occurrence.

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

(status)

(Required) Specify the status of the existing occurrence.

Valid Entries:: T001—T999
Default Value:: (No default)

(pswd)

(Optional) Specify a password to protect this occurrence from unauthorized updates. For information about protecting definitions, see 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. See the section on 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 AREA occurrence in the same status to use as the model for the occurrence you are adding. Any aliases or descriptors assigned to the existing occurrence are not duplicated for the new occurrence.

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

When you press Enter, the AREA definition panel appears. Complete the definition of the AREA occurrence by assigning attribute-values in the AREA ATTRIBUTES region.

 =>
 =>
 =>
 1-DDOL000407I - UAIP - AREA HAS NO RELATED TABLE
-----------------------------------------------------------------------------
 DATACOM/DB STRUCTURE MAINTENANCE                                      MODIFY
                                                                         TUAU
 .............................. AREA  ATTRIBUTES ............................
 Name: ACCTS                                  Status/Version: T001
 DB-Name: ___  Blksz: _____  Space-Mgt: _  Slack: ____

 ..............................TABLE  ATTRIBUTES ............................
        Name                     Mstr-Ky          Cluster  Compress
         DB-Nm  SQL Pa Log Recvr Chg Dup Pipe     Len Id    Y/N Exit  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 following list describes each attribute, the valid entries, and the default (if one exists). Attributes that require an entry are highlighted on your terminal. Attributes which are not highlighted indicate that an entry is optional. If you do not assign a value to these attributes, they default to the value assigned in CA Datacom Datadictionary.

DB-Name:

(Required) Specify a name that is unique among the areas defined to the DATABASE structure. It cannot contain leading, embedded, or trailing blanks (X'40'). CA Datacom/DB uses this name to identify the area.

Note: If this area is to contain one or more partitioned table structures, this attribute must have a value of $$P.

For more information, see the DATACOM-NAME attribute-type for AREA occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: A unique set of three characters where the first character is alphabetic
Default Value:: (No default)

Blksz:

(Required) Specify the physical block size of the area.

For more information, see the BLOCK-SIZE attribute-type for AREA occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

Minimum: 512 bytes

Maximum: Track size or 32760 bytes, whichever is less

Default Value:

(No default)

Space-Mgt:

(Optional) Specify the space management option.

Valid Entries:

0 - no space reclamation

1 - basic space reclamation

2 - wraparound

3 - clustering

Default Value:

Slack:

(Optional) Specify the number of bytes reserved in the data block area for the expansion of compressed records if the displayed attribute-value is different from the desired value. Space is provided for compressed records that are prone to expand over time due to updates.

Valid Entries:: Number less than block size
Default Value:: (No default)

Add Tables to the AREA

The TABLE ATTRIBUTES region of the panel contains one set of lines to define a TABLE substructure. You can add more lines with the line commands to define additional TABLE substructures on this panel.

Name

(Required) Specify the name for the TABLE occurrence you are adding.

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

DB-Nm

(Required) Specify a name that is unique among the tables defined to the DATABASE structure.

For more information, see the DATACOM-NAME attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: A unique set of three characters where the first character is alphabetic
Default Value:: (No default)

SQL

(Optional) Enter Y to indicate that you want this table to be accessible using all SQL statements. Enter an R (read-only) if the table is to be accessible for SQL using only the read statements (SELECT, FETCH, and so on). For more information about restrictions for creating SQL accessible tables, see the CA Datacom/DB SQL User Guide and the SQL-INTENT attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Specifying N means that no SQL access is allowed.

Valid Entries:: N, Y, or R
Default Value:: N

Pa

(Optional) Specify the role of the table in partitioning.

N - Specifies the table cannot be involved in any partitioning

P - Specifies the table can be a table partition

R - Specifies the table can be partitioned but with restricted access

Y - Specifies the table can be partitioned

Note: If this attribute has a value of Y or R, the DB-Name attribute of the area must have a value of $$P.

For more information, see the PARTITION attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: N, P, R, or Y
Default Value:: N

Log

(Optional) Specify Y (Yes) if CA Datacom/DB is to log all maintenance against this table in the CA Datacom/DB Log Area. If this value is Y, CA Datacom Datadictionary automatically sets the RECOVERY attribute-value to Y.

For more information, see the LOGGING attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: Y or N
Default Value:: Y

Recvr

(Optional) Specify Y (yes) to use CA Datacom/DB recovery facilities.

For more information, see the RECOVERY attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: Y or N
Default Value:: Y

Chg (under Mstr-Ky)

(Optional) Specify Y (Yes) if the data in the Master Key can be changed.

If the TABLE is created in SQL, the value defaults to Y.

For more information, see the CHNG-MASTER-KEY attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: N or Y
Default Value:: N

Dup (under Mstr-Ky)

(Optional) Specify Y (Yes) if the data in the Master Key can be duplicated.

If the TABLE is created through SQL, the value defaults to Y. For more information, see the DUPE-MASTER-KEY attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: N or Y
Default Value:: N

Pipe

(Optional) Specify Y (Yes) if CA Datacom/DB is to use the pipeline feature.

For more information, see the PIPELINE-OPTION attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:: Y or N
Default Value:: Y

Cluster

(Optional) Use the next two attributes to specify whether CA Datacom/DB is to use the clustering space management option.

To use clustering, the SPACE-MNGMNT attribute for AREAs must be 3. For more information, see the CA Datacom/DB Database and System Administration Guide.

Len

Specify the number of high-order digits of the Native Key that constitute the cluster key of the table.

For more information, see the CLUSTER-KEY-LEN attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries: 1-177

Default Value: 0

Id

(Optional) Specify an identification number if the table uses the clustering space management option.

For more information, see the CLUSTER-KEY-ID attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries: A previously unassigned 3-digit KEY occurrence DATACOM-ID from 1 to 999

Default Value: If clustering is specified, but no Len field is entered, CA Datacom Datadictionary generates a unique DATACOM-ID for the key within the DATABASE structure.

If clustering is not specified, 0 is used.

Compress

(Optional) Use the next two attributes to specify if CA Datacom/DB is to use compression with this table. Compression removes three or more consecutive blanks, character zeros, or binary zeros.

Y/N

(Optional) Specify Y (yes) if CA Datacom/DB is to use the standard CA Datacom/DB data compression facility for this table.

For more information, see the COMPRESSION attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries: N or Y

Default Value: N

Exit

(Optional) Supply the name of the compression exit to implement a user compression routine to compress this table.

Fore more information, See the COMPRESS-EXIT attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries: 1- to 8-character name of routine

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 on protecting definitions in the CA Datacom Datadictionary User Guide.

Valid Entries:: 0, 1, or 2
Default Value:: 0

Press PF9 (APPLY) after completing your entries. If there are no errors, CA Datacom Datadictionary displays an indented structure containing the AREA occurrence and the TABLE occurrences that you defined.

You can enter margin commands on the indented structure to place an occurrence and a function in the online work queue. For example, enter the DEF margin command in the line number for the TABLE occurrence to define the FIELD occurrences for the TABLE substructure. For more information, see Define FIELD Occurrences to a TABLE.