SAS/ACCESS Interface to CA-DATACOM/DB: Reference

CA-DATACOM/DB and CA-DATADICTIONARY Software

CA-DATACOM/DB is a database management system (DBMS). Databases are fully defined with CA-DATADICTIONARY.

A CA-DATACOM/DB database consists of various entity-types, which can occur one or more times. For example, a database has areas, files, and records. Each data record in a table has one or more fields. The order of the data records is determined by the values for the field specified as the Native Key. Each field contains one type of data, and each record can hold one data value for each field, except that a repeating field can assume many values.

Note: CA-DATACOM/DB data views are not supported by the SAS/ACCESS interface to CA-DATACOM/DB. [cautionend]

CA-DATADICTIONARY is a central, integrated, and active control facility, which provides the basis for shared and consistent system resource management. As a repository for descriptive data, CA-DATADICTIONARY is your tool for

managing definitions and syntax
enforcing naming conventions
creating data relationships
managing test and production environments.

CA-DATADICTIONARY allows you to collect information in categories called entity-types. Any data you enter into CA-DATADICTIONARY are associated with a category, that is, an entity. For example, DATABASE, AREA, and FIELD are some specific CA-DATADICTIONARY entities.

Each instance within the entity is an entity-occurrence. For example, defining a database involves storing information about the database in the DATABASE occurrence. Each database is listed by its unique name as an occurrence of the DATABASE entity.

Each occurrence has specific attributes such as data type. These attributes enable you to describe specific properties of each occurrence. For example, you can specify the type of data that a field contains or whether a key is a Master Key or a Native Key. The actual information you store for each attribute is an attribute value. In addition, CA-DATADICTIONARY allows you to define support data, such as aliases, CA-DATACOM/DB descriptors, text, and relationships.

CA-DATADICTIONARY allows you to have many copies (versions) of the same occurrence. Each version of an occurrence can have one status at a given time. Only TEST and PROD are allowed with the SAS/ACCESS interface to CA-DATACOM/DB. The five status values are

TEST
PRODuction
HISTory
INCOmplete
QUALified production.

Depending on your site, you may find that using CA-DATADICTIONARY online is more efficient for some tasks, while other tasks are simpler with batch jobs.

For more information about CA-DATADICTIONARY and other CA-DATACOM/DB features or administration of CA-DATACOM/DB databases, see the appropriate CA-DATACOM/DB documentation.

Chapter Contents
Previous
Next
Top of Page