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

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
Sequencing secondary files for a primary join 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 character functions . . . . . . . . . . . . . . . . . . . . . . . . 61
Date, time, and timestamp expressions in Query for iSeries . . . . . . . . . . . . . . . . 66
Displaying constants format in Query for iSeries . . . . . . . . . . . . . . . . . . . . 69
Date, time, and timestamp arithmetic operations in Query for iSeries . . . . . . . . . . . . . 69
Date arithmetic operation in Query for iSeries . . . . . . . . . . . . . . . . . . . . . 70
Time arithmetic operation in Query for iSeries . . . . . . . . . . . . . . . . . . . . . 73
Durations in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Date, time, and timestamp functions in Query for iSeries . . . . . . . . . . . . . . . . . . 74
CHAR Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 74
DATE Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 75
DAY Query for iSeries function
. . . . . . . . . . . . . . . . . . . . . . . . . . 75
DAYS Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 76
HOUR Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 76
MICROSECOND Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . 77
MINUTE Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . 77
MONTH Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . 78
SECOND Query for iSeries function. . . . . . . . . . . . . . . . . . . . . . . . . 78
TIME Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 79
TIMESTAMP Query for iSeries function
. . . . . . . . . . . . . . . . . . . . . . . 79
YEAR Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 80
Additional date, time, and timestamp functions in Query for iSeries . . . . . . . . . . . . . 80
Converting date formats in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . 80
Converting date for output to a database file in Query for iSeries . . . . . . . . . . . . . . 80
Converting date for output to a display or printer in Query for iSeries
. . . . . . . . . . . . 81
General considerations when creating an expression in Query for iSeries . . . . . . . . . . . . 83
Column headings in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . 85
Length and decimal positions in Query for iSeries
. . . . . . . . . . . . . . . . . . . . 85
Example of defining a result field in Query for iSeries . . . . . . . . . . . . . . . . . . 86
Adding or removing result fields in Query for iSeries . . . . . . . . . . . . . . . . . . . 86
Chapter 6. Selecting and sequencing fields in Query for iSeries . . . . . . . . . . . . . . 87
Letting Query for iSeries select and sequence fields. . . . . . . . . . . . . . . . . . . . 87
Selecting fields and specifying their sequence in Query for iSeries . . . . . . . . . . . . . . 87
Chapter 7. Selecting records in Query for iSeries . . . . . . . . . . . . . . . . . . . 91
iv Query for iSeries Use V5R2