Preliminary Concepts › Components of a CA Ideal Application › Dataview Definition

Dataview Definition

A dataview is a logical view of data that lets you make requests of the data independently of the storage structure.

Dataview definitions for accessing CA Datacom/DB tables using native command access are created and maintained in the Datadictionary.

CA Ideal maintains dataview definitions for SQL access, both for CA Datacom/DB objects and DB2 objects, in the dictionary facility. The CA Datacom/DB tables, views, and synonyms are created and maintained in the Datadictionary. The DB2 tables and views are created and maintained in the DB2 catalog.

There are two types of dataview definitions for sequential files:

• CA Datacom/DB sites create and maintain modeled sequential file dataviews in Datadictionary.
• Unmodeled sequential file dataview definitions are created and maintained in the Virtual Library System (VLS) and the dictionary facility. CA Datacom/DB and DB2 sites can use them.

CA Ideal treats modeled and unmodeled dataview definitions for sequential files identically once they are cataloged.

Like dataview definitions for unmodeled sequential files, dataview definitions for VSAM files are created and maintained in the Virtual Library System (VLS) and the dictionary facility.