IBM ISERIES SC41-5210-04 - Manual (Page 5)

Contents
About Query for iSeries Use . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
Who should read the Query for iSeries Use book . . . . . . . . . . . . . . . . . . . . . ix
Part 1. Introduction to Query for iSeries . . . . . . . . . . . . . . . . . . . . 1
Chapter 1. What is Query for iSeries? . . . . . . . . . . . . . . . . . . . . . . . . 3
Query for iSeries fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Files, fields, and record formats in Query for iSeries . . . . . . . . . . . . . . . . . . . 3
Query for iSeries definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Libraries in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Major functions of Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Chapter 2. General operating information for Query for iSeries . . . . . . . . . . . . . . 7
Practicing with Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Getting started with Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . 7
When you are finished working with Query for iSeries . . . . . . . . . . . . . . . . . . 7
Telling Query for iSeries what you want . . . . . . . . . . . . . . . . . . . . . . . . . 7
Using prompts and default values in Query for iSeries . . . . . . . . . . . . . . . . . . 7
Using Query for iSeries function keys
. . . . . . . . . . . . . . . . . . . . . . . . 8
Using lists in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Using Query for iSeries commands . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Using the Query Utilities menu. . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Using the Work with Queries display
. . . . . . . . . . . . . . . . . . . . . . . . . 12
Choosing a single Query for iSeries task . . . . . . . . . . . . . . . . . . . . . . . 12
Choosing multiple Query for iSeries tasks
. . . . . . . . . . . . . . . . . . . . . . 13
Working with a list of Query for iSeries queries . . . . . . . . . . . . . . . . . . . . 14
Selecting a library for your Query for iSeries queries . . . . . . . . . . . . . . . . . . 16
Displaying the format of constants in Query for iSeries . . . . . . . . . . . . . . . . . . . 17
Query for iSeries profile information . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Handling Query for iSeries messages and errors . . . . . . . . . . . . . . . . . . . . . 18
Changing your Query for iSeries queries . . . . . . . . . . . . . . . . . . . . . . . 18
Part 2. Defining and using Query for iSeries query definitions . . . . . . . . . 21
Chapter 3. Creating a Query for iSeries query definition . . . . . . . . . . . . . . . . . 27
Starting Query for iSeries query definition
. . . . . . . . . . . . . . . . . . . . . . . 27
Selecting definition steps when defining a Query for iSeries query . . . . . . . . . . . . . . 28
Selecting options for a Query for iSeries query definition . . . . . . . . . . . . . . . . . 29
Moving through the Query for iSeries definition displays . . . . . . . . . . . . . . . . . 30
When you return to the Query for iSeries Define the Query display . . . . . . . . . . . . . 30
Considerations for creating Query for iSeries queries . . . . . . . . . . . . . . . . . . . 30
Selecting files, records, and fields for Query for iSeries . . . . . . . . . . . . . . . . . 30
Suggested sequence of tasks for creating Query for iSeries queries . . . . . . . . . . . . . 31
Chapter 4. Specifying and selecting files for a Query for iSeries query . . . . . . . . . . . 33
Specifying file selections for a Query for iSeries query . . . . . . . . . . . . . . . . . . . 33
Choosing a file for a Query for iSeries query . . . . . . . . . . . . . . . . . . . . . 34
Choosing a library for a Query for iSeries query . . . . . . . . . . . . . . . . . . . . 34
Choosing a member or record format for a Query for iSeries query . . . . . . . . . . . . . 35
Selecting multiple files for a Query for iSeries query . . . . . . . . . . . . . . . . . . . 35
Confirming your options for a Query for iSeries query . . . . . . . . . . . . . . . . . . 36
Handling errors on the Query for iSeries Specify File Selections display . . . . . . . . . . . 36
© Copyright IBM Corp. 2000, 2002 iii