Previous Topic: Defining Entity-Occurrences in the DatadictionaryNext Topic: Defining Keys


Defining Tables

Do not specify logging for any of the CA Dataquery system tables, except the DQQ table (Query Library).

When defining tables, make the entity-occurrence names different for TABLE, KEY, and COLUMN entity-occurrences so that CA Dataquery can unambiguously resolve references in queries. Make the COLUMN, ELEMENT, and KEY entity-occurrence names unique within each row. Do not give a column the same name as a key in the same row. CA Dataquery selects the first entity-occurrence it finds with the requested name and ignores any other entity-occurrence with that name. Do not use CA Dataquery reserved words as TABLE, COLUMN, or KEY entity-occurrence names. If it is necessary to do so, you can define aliases to use when accessing the data with CA Dataquery. See the CA Dataquery User Guide or CA Dataquery Reference Guide for a list of reserved words.

Each table should have at least one unique key defined for it.