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

Page 43
Image 43
IBM SC41-5210-04 manual Creating a Query for iSeries query definition