A query is a series of steps and their associated tasks used to retrieve specific data from the mainframe for analysis.
Composing queries in Q&R Query is a simple matter of specifying the steps required to get the information you want. These steps include specifying where the information comes from, how to examine it, and what information to include in the output.
By default each step works on the output from the previous step. The steps are processed sequentially to produce the final output. After your query is ready, it can be run directly from within Q&R Query.
To compose a new query
The New Query panel appears.
Provides the name for the query. It is used internally by the system and in the creation of directories and files used to identify and manage query output.
Limit: 6 characters
Specifies the query title, a descriptive name for the query. The title is the default name for the query output.
Note: The name and title are used to construct the default name of the query definition file that you can save for later use. Query definition files use the file extension QRQ.
Provides an area to enter a description of the query being created, letting you self-document your query. This information is visible while editing the query and can be useful for describing the intent of the query.
(Optional) Provides a starting point to create queries. The Finder button enables you to select a template that uses predefined steps and tasks.
The Q&R Query panel appears. You can define the steps and tasks you want to use in this query, or you can modify the steps supplied through a template.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |