Using CREATE in SQL Mode

Using CREATE in SQL Mode

SQL is a comprehensive way to query your database. Use these sections to gain confidence in using:

• The CA Dataquery EDITOR
• The SQL template
• Basic SQL key words in a simple query
• CA Dataquery to solve a business problem

Note: If you like, you can follow the next lessons by using your own data and the correct names for your own database.

Once you have read these sections, you should be comfortable using the CA Dataquery Reference Guide to create queries that solve your business problems.

Prerequisites

Familiarity with the database concepts and terminology discussed in Understanding the Terminology is suggested prior to reading these sections for the first time.

Content

The following sections present the concepts for building a basic query using the CA Dataquery EDITOR. Included in them are:

• A brief overview of the EDITOR panel
• Advice on planning a query
• An example of a typical business situation and a sample query that meets the need
• A tutorial on creating the sample query
• Information about defining a default report format for use whenever the query is executed

On Your Own

These sections provide enough information for you to start creating your own SQL queries on the EDITOR. They also provide introductions to some advanced SQL query capabilities and to defining the format of the query output. If you want more information as you create your own queries, display the Help panels or turn to the CA Dataquery Reference Guide or the CA Datacom/DB SQL User Guide.