CA Dataquery in the CA Datacom System

CA Dataquery in the CA Datacom System

CA Dataquery is the information retrieval and data manipulation component of the CA Information Center products. CA Dataquery operates in both online and batch environments to allow you to access and manipulate data from the database and display the results in an easily read format.

Product Definition

CA Dataquery is an easy-to-use tool for accessing the most up-to-date information in your database. CA Dataquery not only retrieves the data, it also offers many options for manipulating, formatting, saving, and passing data to other programs. With special authorization, you can use CA Dataquery to change the data in your database. See Modifying Data Using CA Dataquery for more information about this subject.

You can use a query to retrieve the data and format it on your terminal screen or print it on a printer. The query that performs these tasks for you can be written in either DQL Language or SQL, (query languages that use easy-to-understand English).

Languages

CA Dataquery supports two query languages:

• FIND, SORT and PRINT are examples of DQL Language.
  • FIND tells CA Dataquery which database table to read
  • SORT tells CA Dataquery how to sort the rows
  • PRINT tells CA Dataquery which data to display in columns

  The DQL Language provides keywords for qualifying the retrieved data, making calculations, and controlling how the data appears in your report.

• SELECT, FROM, and WHERE are examples of SQL.
  • SELECT tells CA Dataquery which column of a database table to retrieve
  • FROM tells CA Dataquery which database table contains the column
  • WHERE tells CA Dataquery what conditions to apply to the retrieved information

Reporting

CA Dataquery provides a wide variety of common reporting capabilities. For instance, you can sort found data by any sort criteria, limit data selection, choose to report detail or summary data, and change report formats.