Administration Guide › CA Dataquery in the CA Datacom System › Preparing and Maintaining System Tables

Preparing and Maintaining System Tables

The following tables must be present in CA Datacom/DB to run CA Dataquery with the SQL option installed. Some of the tables also include set allocations.

Note: For more information about space allocations, see the CA Datacom Installation and Maintenance Guide.

DQE

SQL Found Table - Contains the rows of the data returned by an SQL query.

DQF

CA Dataquery Found Table - Stores the results of a query or found set. The found set that results from a query remains active until another query is executed or the user signs off.

DQM

CA Dataquery Literals Table - Stores literal values that are output by the CA Dataquery system. These literal values are keywords and phrases that are commonly used by the CA Dataquery system.

DQP

CA Dataquery Panel Table - Stores the image of the panels that collectively comprise the CA Dataquery External Online Interface. Storing panel images on this table facilitates their translation into other languages by the CA Dataquery Language Maintenance Facility.

DQQ

CA Dataquery Query Library - Primarily stores query text members, JCL members, PROCs, terms, condition, and restriction definitions.

DQR

CA Dataquery Recovery Table - Contains one row for each Found Set in the DQE. It also contains some record keeping data, such as who created the Found Set, when it was created, and so on.

DQS

CA Dataquery Spool Table - Stores and controls the hardcopy report output of a query that has been routed to an online network printer.

DQU

CA Dataquery User Table - Stores the definitions of valid CA Dataquery users. This table contains user attributes such as name, password, language, system options and function authorizations. This information is used to validate a user attempting to sign on to the CA Dataquery system.

DQV

CA Dataquery Vocabulary Table - Stores Language and Command keywords that a CA Dataquery user would enter into the system. Storing these keywords on this table facilitates their translation into other languages by the CA Dataquery Language Maintenance Facility.

DQW

CA Dataquery Work Table - Performs as the batch equivalent of the DQF table. The Work Table stores and manages found sets that result from batch queries.