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

Part 2. Defining and using Query for iSeries query definitions
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
Using file IDs for a Query for iSeries query . . . . . . . . . . . . . . . . . . . . . 36
Confirming your options for a Query for iSeries query . . . . . . . . . . . . . . . . . . 36
Removing a option for a Query for iSeries query . . . . . . . . . . . . . . . . . . . 36
Handling errors on the Query for iSeries Specify File Selections display . . . . . . . . . . . 36
Selecting files on the Query for iSeries Select File display . . . . . . . . . . . . . . . . . 37
Selecting file members on the Query for iSeries Select Member display . . . . . . . . . . . . 39
Selecting record formats on the Query for iSeries Select Record Format display . . . . . . . . . 40
Displaying all files selected on the Query for iSeries Display File Selections display . . . . . . . . 41
Joining files in a Query for iSeries query . . . . . . . . . . . . . . . . . . . . . . . . 42
Types of joins in a Query for iSeries query . . . . . . . . . . . . . . . . . . . . . . 43
How to join files in a Query for iSeries query . . . . . . . . . . . . . . . . . . . . . 43
Rules for joining files in a Query for iSeries query
. . . . . . . . . . . . . . . . . . . 44
Examples of joining files in a Query for iSeries query . . . . . . . . . . . . . . . . . . 46
Example: Selecting matched records from all selected files in a Query for iSeries query . . . . 47
Example: Selecting matched records using a primary file in a Query for iSeries query . . . . . 48
Example: Selecting unmatched primary file records in a Query for iSeries query . . . . . . . 48
Sequencing secondary files for a primary join in a Query for iSeries query . . . . . . . . . . 49
Example: Sequencing secondary files in a Query for iSeries query . . . . . . . . . . . . 49
Displaying all join tests in a Query for iSeries query . . . . . . . . . . . . . . . . . . . . 53
Handling missing fields in a Query for iSeries query . . . . . . . . . . . . . . . . . . . . 54
Handling missing fields during file selection process of a Query for iSeries query . . . . . . . . 55
Handling missing fields when starting to change or display a Query for iSeries query
. . . . . . 55
Chapter 5. Defining result fields in Query for iSeries . . . . . . . . . . . . . . . . . . 57
Creating results fields in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . 57
Query for iSeries result field name . . . . . . . . . . . . . . . . . . . . . . . . . 58
Query for iSeries expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Query for iSeries numeric expressions. . . . . . . . . . . . . . . . . . . . . . . . 59
Query for iSeries character expressions . . . . . . . . . . . . . . . . . . . . . . . 60
Query for iSeries concatenation operation . . . . . . . . . . . . . . . . . . . . . 60
Query for iSeries character functions . . . . . . . . . . . . . . . . . . . . . . . . 61
SUBSTR Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . 61
DIGITS Query for iSeries function
. . . . . . . . . . . . . . . . . . . . . . . . 62
VALUE Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . 62
VARCHAR Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . 63
VARGRAPHIC Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . 65
Date, time, and timestamp expressions in Query for iSeries . . . . . . . . . . . . . . . . 66
© Copyright IBM Corp. 2000, 2002 21