1*

IDENTIFY NEW QUERY
Note: This step is only required if you want to save the query.

a*

Name the query and designate public or private library.

EDITOR: CREATE MODE

2*

SELECT FIRST TABLE

a*

Select the FIND statement or type it in.

QUERY TEMPLATE
EDITOR: CREATE MODE

b*

Select the first or only database table you want to search or type in the table name.

DIRECTORY OF TABLES
EDITOR: CREATE MODE

3

SPECIFY SEARCH CRITERIA FOR FIRST TABLE

a

Select the WITH statement or type it in.

QUERY TEMPLATE
EDITOR: CREATE MODE

b

Select the columns to search for specific conditions or type in the column names.

DIRECTORY OF TABLES
EDITOR: CREATE MODE

c

Define each search condition.

EDITOR: CREATE MODE

d

Logically group conditions using AND, OR, and parentheses.

EDITOR: CREATE MODE

4

SELECT AND JOIN SECOND TABLE

a

Select relationship statement or type it in.

QUERY TEMPLATE
EDITOR: CREATE MODE

b

Select key or column name for join or type in key or column name.

KEY OR COLUMN DISPLAY
EDITOR: CREATE MODE

c

Select second database table to search or type in table name.

DIRECTORY OF TABLES
EDITOR: CREATE MODE

5

SPECIFY SEARCH CRITERIA FOR SECOND TABLE

a

Select the WITH statement or type it in.

QUERY TEMPLATE
EDITOR: CREATE MODE

b

Select the columns to search for specific conditions or type in the column names.

DIRECTORY OF TABLES
EDITOR: CREATE MODE

c

Define each search condition.

EDITOR: CREATE MODE

d

Logically group conditions by using AND, OR, and parentheses.

EDITOR: CREATE MODE

6

SET UP TEMPORARY RESULTS

a

Select SET statement or type it in.

QUERY TEMPLATE

b

Type in name of new result and specify the precision.

EDITOR: CREATE MODE

c

Select columns to be included in the arithmetic expression for a new column or type in the column names.

COLUMN DISPLAY
EDITOR: CREATE MODE

d

Specify the arithmetic operation to be performed (+, -, /, *), and group operations logically using parentheses.

EDITOR: CREATE MODE

7

SORT REPORT DATA

a

Select SORT statement or type it in.

QUERY TEMPLATE
EDITOR: CREATE MODE

b

Select columns to control report sorting of data or type in the column names.

COLUMN DISPLAY
EDITOR: CREATE MODE

c

Specify sort order, sequence, breaks in control of totaling operations, new page generation.

EDITOR: CREATE MODE

8*

DEFINE REPORT APPEARANCE AND CONTENT

a*

Select PRINT or DISPLAY statement or type in the statement.

QUERY TEMPLATE
EDITOR: CREATE MODE

b*

Select columns/keys whose contents are to be printed on the report or type in the column/key names.

COLUMN OR KEY DISPLAY
EDITOR: CREATE MODE

c

Specify columns which are to be totaled in report by enclosing in parentheses.

EDITOR: CREATE MODE

d

Specify a format for numeric data.

EDITOR: CREATE MODE

e

Give your own titles to columns.

EDITOR: CREATE MODE

f

Select WHEN-DO statement or type it in.

QUERY TEMPLATE
EDITOR: CREATE MODE

g

Specify when and what math functions are to be performed on which columns, if any.

EDITOR: CREATE MODE

9*

VALIDATE QUERY

a

Check query for syntax or database information errors.

EDITOR: CREATE MODE
EDITOR: PROCESS MODE