The GUIDE function allows you to preselect the components of your query. Depending on your selections, it prompts you through each step of building a simple or fairly complex query. You cannot leave out a required step. All you do is respond to each panel as it appears by making entries or skipping the panel where permitted.
Options
In addition to building a query by completing panels with the Guided Query Creation function, you can:
A special PF key is available at any point in building a query that will display the actual query CA Dataquery is creating for you. If you like, you can press this key after completing any panel and see how a query keyword, like FROM, relates to a step you have completed.
With Guided Query, you respond to panels and create the same query you might create by writing SQL, with only a few restrictions.
Restrictions
Guided Query should not be your choice if you want to:
When naming such things as queries, dialogs, tables, or any CA Datacom item, do not use words from the following categories:
Since these words have special meanings to CA Dataquery or are ignored by CA Dataquery, failure to avoid them will cause problems when you execute any query containing them. A complete list of reserved and ignored words appears in the CA Dataquery Reference Guide.
Procedure
If you want your query to perform functions not available with the GUIDE option and you still want to use Guided Query, you can. All you do is create the basic query with GUIDE and add the extra functions by editing your query with the CA Dataquery EDITOR. For example, you can edit the query you create with Guided Query to make a dialog. You can access the query through the Main Menu DIRECTORIES option or by using the EDIT command. See the CA Dataquery Reference Guide for instructions. See Reviewing the Process for more information about dialogs.
|
Copyright © 2014 CA.
All rights reserved.
|
|