Previous Topic: FILE Occurrence in CA FILE ModelNext Topic: KEY Occurrence in CA FILE Model


KEY Occurrence in CA Datacom/DB Model

Entity-Type Occurrence-Name Use DB-Name DB-Id Length Options 000019 KEY ORDER-ID-KEY I ACTOR 004 00005 YYY


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 type of key: I for a regular indexing key or P for a partitioning key. (KEY-TYPE)

DB-Name

1

5

DB-Name (DATACOM-NAME)

DB-Id

1

3

Key Id (DATACOM-ID)

Length

1

5

Sum of lengths of fields

Options

1

 

Master-Key or Mst (MASTER-KEY)

 

2

1

Native-Seq or Nat (NATIVE-KEY)

 

3.

1

Nil (INCLUDE-NIL-KEY)

Note: The key 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.