Introducing CA Dataquery Query Creation

These are the types of queries you can create with CA Dataquery:

Queries that return data as specified
COUNT queries
Dialogs

Definition

Your primary objective in using CA Dataquery is retrieving data. To do that, you construct different kinds of queries, execute them, and look at the results. You can print the results, display them on your terminal screen, or export them to sequential files for use by other products or programs. Unless you have someone create your queries for you, you must learn how to construct a query.

Example

A query can be as simple or as sophisticated as you need it to be. You can make a simple query that finds and displays customer names and phone numbers:

SELECT NAME, PHONE
FROM CUSTOMER

Variations

CA Dataquery can do more than retrieve and display data. You could alter the preceding simple query to perform the following:

Specify search criteria
Retrieve data from two or more tables
Present the results of mathematical calculation
Sort the data
Allow parts of it to be completed at execution
Count the number of rows of specific data

Report Definition

You can define reports in two ways in CA Dataquery. In DQL Mode, the way you use keywords to write the query specifies most of the format of the report. In SQL Mode, an online function allows you to specify a default report and to re-specify the report with each execution.