IBM ISERIES SC41-5210-04 User Manual

Page 43

Advertising
background image

Suggested sequence of tasks for creating Query for iSeries queries

The following is a suggested sequence of tasks to create queries:

1. Define result fields before selecting and sequencing fields.

2. Specify comparisons used for selecting records before selecting and sequencing fields.

3. Select and sequence fields and specify sort fields before you reformat columns.

4. Select sort fields before you define report breaks.

5. Press F5 to view your query results and F13 to view your report layout before and after you reformat

columns.

You can use a query to quickly sort records in a data file. Simply select the sort fields, choose database
as the output device, and specify the output database name.

Chapter 3. Creating a Query for iSeries query definition

31

Advertising