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

Numeric constants as values in Query for iSeries. . . . . . . . . . . . . . . . . . . 94
Date, time, timestamp constants as values in Query for iSeries
. . . . . . . . . . . . . 95
Null values in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . 95
Comparison tests in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . 95
Date, time, or timestamp comparisons in Query for iSeries . . . . . . . . . . . . . . . 96
Testing for equal (EQ) and not equal (NE) in Query for iSeries . . . . . . . . . . . . . . 96
Testing for IS Null (IS) and ISNOT Null (ISNOT) in Query for iSeries
. . . . . . . . . . . 96
Testing for greater (GT or GE), less (LT or LE), and range (RANGE) in Query for iSeries . . . . 96
Testing for values in a list (LIST NLIST) in Query for iSeries . . . . . . . . . . . . . . . 97
Testing for values that are similar (LIKE NLIKE) in Query for iSeries . . . . . . . . . . . . 98
Testing for DBCS LIKE (like) and NLIKE (not like) in Query for iSeries . . . . . . . . . . . 99
Using more than one comparison test in Query for iSeries . . . . . . . . . . . . . . . . 101
Adding and removing comparisons in Query for iSeries . . . . . . . . . . . . . . . . . 103
Chapter 8. Selecting sort fields in Query for iSeries . . . . . . . . . . . . . . . . . . 105
Letting Query for iSeries determine the order of records for you . . . . . . . . . . . . . . . 105
Selecting the sort fields you want to use in Query for iSeries . . . . . . . . . . . . . . . . 105
Additional sort considerations in Query for iSeries . . . . . . . . . . . . . . . . . . . 108
Chapter 9. Selecting a collating sequence in Query for iSeries . . . . . . . . . . . . . . 111
Letting Query for iSeries select a collating sequence . . . . . . . . . . . . . . . . . . . 111
Setting your default collating sequence in Query for iSeries. . . . . . . . . . . . . . . . 111
Purpose of a collating sequence in Query for iSeries . . . . . . . . . . . . . . . . . . . 111
Collating sequence and CCSIDs in Query for iSeries . . . . . . . . . . . . . . . . . . 112
How a collating sequence affects Query for iSeries. . . . . . . . . . . . . . . . . . . . 112
Selecting a Query for iSeries collating sequence
. . . . . . . . . . . . . . . . . . . . 113
Using the hexadecimal collating sequence in Query for iSeries . . . . . . . . . . . . . . 113
Using the language collating sequence for your country in Query for iSeries
. . . . . . . . . 114
Defining your own collating sequence in Query for iSeries . . . . . . . . . . . . . . . . 115
Selecting a translation table in Query for iSeries. . . . . . . . . . . . . . . . . . . . 116
Selecting a system sort sequence in Query for iSeries
. . . . . . . . . . . . . . . . . 117
Chapter 10. Specifying report column formatting in Query for iSeries . . . . . . . . . . . 119
Formatting the columns of the Query for iSeriesquery report . . . . . . . . . . . . . . . . 119
Column spacing in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . 119
Column headings in Query for iSeries reports. . . . . . . . . . . . . . . . . . . . . 119
Length and decimal positions in Query for iSeries reports . . . . . . . . . . . . . . . . 120
Omitting fields from a Query for iSeries report
. . . . . . . . . . . . . . . . . . . . 121
Editing numeric fields in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . 122
Defining numeric field editing in Query for iSeries reports . . . . . . . . . . . . . . . . 122
Describing numeric field editing in Query for iSeries reports
. . . . . . . . . . . . . . . 124
Decimal point in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . 125
Thousands separator in Query for iSeries reports . . . . . . . . . . . . . . . . . . 125
Show negative sign in Query for iSeries reports . . . . . . . . . . . . . . . . . . . 125
Left negative sign in Query for iSeries reports
. . . . . . . . . . . . . . . . . . . 125
Right negative sign in Query for iSeries reports . . . . . . . . . . . . . . . . . . . 126
Show currency symbol in Query for iSeries reports. . . . . . . . . . . . . . . . . . 126
Left currency symbol in Query for iSeries reports . . . . . . . . . . . . . . . . . . 126
Right currency symbol in Query for iSeries reports . . . . . . . . . . . . . . . . . . 126
Print zero value in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . 127
Replace leading zeros in Query for iSeries reports . . . . . . . . . . . . . . . . . . 127
Replace with option in Query for iSeries reports . . . . . . . . . . . . . . . . . . . 127
Single leading zero in Query for iSeries reports . . . . . . . . . . . . . . . . . . . 127
Describing date/time field editing display in Query for iSeries reports . . . . . . . . . . . . 127
Date/time separator in Query for iSeries reports . . . . . . . . . . . . . . . . . . . 128
Specifying an edit code in Query for iSeries reports . . . . . . . . . . . . . . . . . . 129
Part 2. Defining and using Query for iSeries query definitions 23