Chapter Contents


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


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

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

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



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.