Filter
Top Products
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