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

Letting Query for iSeries select records . . . . . . . . . . . . . . . . . . . . . . . . 91
Selecting the records you want in Query for iSeries . . . . . . . . . . . . . . . . . . . . 91
Comparison fields in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . 92
Comparison values in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . 93
Comparison tests in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . 95
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
Describing date/time field editing display in Query for iSeries reports . . . . . . . . . . . . 127
Specifying an edit code in Query for iSeries reports . . . . . . . . . . . . . . . . . . 129
Specifying edit words
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131
Chapter 11. Specifying report summary functions in Query for iSeries reports . . . . . . . 135
Types of summary functions in Query for iSeries reports . . . . . . . . . . . . . . . . . 135
Summarizing columns in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . 137
Location of column summary values in Query for iSeries reports. . . . . . . . . . . . . . . 137
Chapter 12. Defining Query for iSeries report breaks. . . . . . . . . . . . . . . . . . 139
Defining a Query for iSeries report break . . . . . . . . . . . . . . . . . . . . . . . 139
Defining report break formatting in Query for iSeries reports . . . . . . . . . . . . . . . . 143
Skip to new page in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . 143
Suppress summaries in Query for iSeries reports . . . . . . . . . . . . . . . . . . . 143
Break text in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . . . 144
Chapter 13. Selecting output type and output form in Query for iSeries reports . . . . . . . 145
Selecting the output type and form you want in Query for iSeries reports
. . . . . . . . . . . 145
Form of output of Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . 146
Line wrapping in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . . 146
Wrapping width in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . 147
Contents v