Creating Dataviews for CA Datacom/DB Native Command Access › Rules for CA Datacom/DB Native Command Access › Dataview Key Relationship

Dataview Key Relationship

Although the file model in the dictionary lets the DA relate dataviews to keys through the relationship DVW‑KEY‑ACCESS, CA Ideal does not use these relationships. CA Ideal searches for data according to the fields specified in the program FOR construct's WHERE clause. The application developer does not need to know about actual keys. During execution of an application, CA Ideal searches for the data using an optimized technique that takes advantage of any set of actual keys in the associated file. Therefore, when creating dataview definitions for CA Ideal use, the DA does not need to relate the dataviews to keys since CA Ideal ignores these relationships.