You do not have to know anything at all about SQL or DQL to create a query that accesses one or two tables. If you prefer, you can have CA Dataquery create your queries for you.
All you do is select GUIDE from the Main Menu and let CA Dataquery prompt you for information. The GUIDE function is also an excellent way to learn syntax. Read the chapters on GUIDE for DQL or SQL to get started.
It is also easy to write queries yourself without the aid of the GUIDE function. Simply display the EDITOR panel and enter the keywords. Use the tutorials in this book to get started on using the keywords. Use the CA Dataquery Reference Guide to look up details about each keyword. Use these methods to write queries on the EDITOR:
See Using CREATE in SQL Mode for help in using the CREATE function the first time.
Decision
The choice of whether to use GUIDE, type queries yourself (CREATE function), or use the DRAW command is mostly a matter of preference. However, if you want to retrieve data from more than two database tables at a time, if you want to create a dialog, or if you have become experienced in using GUIDE, you will want to learn the CREATE function. It is faster, once you know the language. And if you do not want to learn the language or use GUIDE, you can still create a query that prints everything in one table by using DRAW.
Whichever function you choose, you can use all of CA Dataquery's power to retrieve and manipulate data, whether you use CA Dataquery every day or only occasionally.
Options
Whether you use GUIDE or CREATE to create queries, you can create new tables from found data. The following pages describe these capabilities.
|
Copyright © 2014 CA.
All rights reserved.
|
|