Previous Topic: RECORD Occurrence in CA FILE ModelNext Topic: Maintaining Tables with Related Constraints

Structure Display Panel › TABLE Occurrence in CA Datacom/DB Model

TABLE Occurrence in CA Datacom/DB Model

        Entity-Type          Occurrence-Name                                Use
                              DB-Name DB-Id  Length  Options

 000003     TABLE            ACCTS-REC                                        Y
                              ACT        006 00031   NNNNY000000YN


Column Heading


Position


Length

Keywords on Panels (Attribute Name)

Entity-Type

varies

varies (indented according to position in structure)

The occurrence name defined in CA Datacom Datadictionary to identify this entity-type. (ENTITY-TYPE)

Occurrence-Name

1

32

The name defined in CA Datacom Datadictionary for this entity-occurrence. (ENTITY-NAME)

Use

1

1

Indicates the role of the table in partitioning. The values are: Y for a partitioned table (the parent); P for a table partition (a child); R for tables that are partitioned but with restricted access, that is, no access to the individual partitions; or N for tables not involved in partitioning. (PARTITION)

DB-Name

1

5

DB-Name (DATACOM-NAME)

DB-Id

1

3

DB-Id (DATACOM-ID)

Length

1

5

Sum of lengths of fields

Options

1

1

Logging (LOGGING)

 

2

1

Recovery (RECOVERY)

 

3.

1

Master-Key Change
(CHNG-MASTER-KEY)

 

4

1

Master-Key Dupe
(DUPE-MASTER-KEY)

 

5

1

Pipeline (PIPELINE)

 

6

3

Cluster-Ky Len (CLUSTER-KEY-LEN)

 

9.

3

Cluster-Ky Id (CLUSTER-KEY-ID)

 

12

1

SQL (SQL-INTENT)

 

13

1

.Compress Y/N (COMPRESSION)

 

14

8

Compress Exit (COMPRESS-EXIT)

Note: The Length value does not include the 2-byte field that defines the data's length for fields defined with a data type of V (VARCHAR). Therefore, this value will not match the sum of the fields length. For more information, see the CA Datacom/DB Database and System Administration Guide.