Add TABLE Substructures

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

Add TABLE Substructures

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

How to Use

Use one of the following procedures to perform this function:

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

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

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

 TO  AREA     ________________________________ in STATUS ____
 TO  ARA      (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

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.

TABLE (name)

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

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

AREA (name)

(Required) Specify 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 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 TABLE occurrence in the same status to use as the model for this occurrence. When you model a TABLE substructure, you also model its FIELD, KEY, and ELEMENT occurrences.

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

If you use this option, any constraints defined to the TABLE substructure are copied with the TABLE .

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

When you press Enter, the TABLE definition panel appears.

 =>
 =>
 =>
 1-DDOL000407I - UTIP - TABLE HAS NO RELATED KEYS/ELEMENTS
-----------------------------------------------------------------------------
 DATACOM/DB STRUCTURE MAINTENANCE                                      MODIFY
                                                                         TUTU
 ............................. TABLE ATTRIBUTES ..............................
 Name: ACCTS                               Status: T001     Partition: _
 DB-Name: ___   SQL:   Logging: _  Recovery: _  Master-Key ( Chg: _  Dup: _ )
 Pipeline: _ Cluster-Ky ( Len: ___ Id: ___ ) Compress ( Y/N: _ Exit:             )

 .......................... KEY/ELEMENT ATTRIBUTES ...........................
       Type                                        ....Key Only.....
       K/E Name                             DB-NM Id Mst Nat Nil Unq Ty Pswd Lck
 ====== =  ====================== 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.

Partition:

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

N - Specifies the table can be not involved in any partitioning

P - Specifies that the table can be a table partition of the table

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 AREA specified must have a DATACOM-NAME attribute 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

DB-Name:

(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 or 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, see the CA Datacom/DB SQL User Guide for details on restrictions for creating SQL accessible tables 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

Logging:

(Optional) Specify Y 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

Recovery:

(Optional) We strongly recommend that RECOVERY be set to Y (yes). Many facilities are only available when RECOVERY=Y.

If you plan to use CA Datacom/DB recovery facilities, enter Y (yes). When you specify Y, 8 bytes are added and reserved in each table entry for logging purposes (current or future). If LOGGING is Y, CA Datacom Datadictionary automatically sets RECOVERY to Y. Tables defined using the SQL CREATE TABLE command have RECOVERY set to Y. For more information, see the CA Datacom/DB Database and System Administration Guide.

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

Master-Key (Chg:)

(Optional) Specify Y 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

Master-Key (Dup:)

(Optional) Specify Y 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

Pipeline:

(Optional) Specify Y 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-Ky

(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:

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 if CA Datacom/DB is to use the standard CA Datacom/DB data compression facility for this table.

Note: If the value of this attribute is Y, the value of EXIT must be blank.

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:

Exit:

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

Note: If the value of this attribute is not blank, the value of COMPRSS must be N.

For 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)