Creating Dataviews for CA Datacom/DB Native Command Access › Defining CA Datacom/DB Native Dataviews › Defining Dataviews

Defining Dataviews

The Data Administrator defines a dataview definition as a named and ordered collection of elements. However, as the CA Ideal application developer, you are concerned with only the constituent columns of these elements. More than one dataview can share an element. Any number of applications can share a dataview.

Using the elements defined in the previous graphic, the following are some of the dataviews that could be defined:

EMPLOYEE            =       element‑1
EMPLOYEE‑IDENT      =       element‑3
EMP‑NO‑SSN          =       element‑6
                            element‑7
EMP‑HIST            =       element‑2
                            element‑4
                            element‑5
EMP‑GEN             =       element‑3
                            element‑4

Since element‑1 and element‑2 have overlapping columns, the following example is illegal:

EMP‑INVALID         =       element‑1
                            element‑2