Using CREATE in SQL Mode › Writing a Sample SQL Query › Meeting the Need

Meeting the Need

The following describes the general phases of resolving the preceding business problem.

Define the need

Create a query that produces a report containing this information:

• Which customers placed orders greater than $1000 in 1987?
• Which salespersons should attend the meeting?

Visualize the report

Determine how the report should look.

Identify tables

Find out which tables contain the needed data.

Identify columns

Find out which columns should be referenced to locate the data.

Decide

Determine whether an existing query or dialog can produce the report. If not, decide whether you want to copy and edit an existing query (or dialog) or write your own. If you want to write your own, decide whether to use GUIDE, CREATE or DRAW. If the existing query was authored by you, you can update it. Make sure to make appropriate changes to the report format.

Begin query creation

Select CREATE from the Main Menu.

Define report

Access the ONLINE EXECUTION panel for the query created. Select <PF3> FORMAT REPORT and enter the printing specifications. These printing specifications are saved and become the defaults for the query whenever it is executed.