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

Edit code in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . . 129
Optional edit code modifier in Query for iSeries reports . . . . . . . . . . . . . . . . 131
Specifying edit words . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131
Edit word in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . . 131
Edit word for summary total in Query for iSeries reports . . . . . . . . . . . . . . . . 133
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
Record on one page in Query for iSeries reports
. . . . . . . . . . . . . . . . . . . 147
Displaying wrapping widths in Query for iSeries reports . . . . . . . . . . . . . . . . . 147
Defining output to the printer in Query for iSeries reports
. . . . . . . . . . . . . . . . 148
Printer device in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . 149
Form size in Query for iSeries reports
. . . . . . . . . . . . . . . . . . . . . . 149
Start line in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . . . 150
End line in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . . . 150
Line spacing in Query for iSeries reports
. . . . . . . . . . . . . . . . . . . . . 150
Print definition in Query for iSeries reports . . . . . . . . . . . . . . . . . . . . . 150
Specifying spooled output overrides in Query for iSeries reports . . . . . . . . . . . . . 150
Defining the printout cover page of Query for iSeries reports . . . . . . . . . . . . . . 152
Defining the page headings and footings in Query for iSeries reports . . . . . . . . . . . 153
Defining output of Query for iSeries reports to a database file. . . . . . . . . . . . . . . 154
Using an existing output file definition in Query for iSeries reports . . . . . . . . . . . . . 155
Building a new output file definition in Query for iSeries reports . . . . . . . . . . . . . . 156
Specifying an output database file for Query for iSeries reports . . . . . . . . . . . . . 157
Summary-only output of a Query for iSeries report to a database file . . . . . . . . . . . 160
Using an output database file created by Query for iSeries . . . . . . . . . . . . . . . . 161
Chapter 14. Specifying Query for iSeries processing options . . . . . . . . . . . . . . 163
Purpose of Query for iSeries processing options . . . . . . . . . . . . . . . . . . . . 163
Rounding numeric field values during Query for iSeries processing . . . . . . . . . . . . . . 164
Ignoring decimal data errors during Query for iSeries processing
. . . . . . . . . . . . . . 164
Ignoring character substitution warnings during Query for iSeries processing . . . . . . . . . . 165
Using collating sequence for all character comparisons during Query for iSeries processing . . . 165
Chapter 15. Exiting and running a Query for iSeries query . . . . . . . . . . . . . . . 167
Ending a Query for iSeries query definition . . . . . . . . . . . . . . . . . . . . . . 167
Saving a Query for iSeries query definition. . . . . . . . . . . . . . . . . . . . . . 167
Storing the Query for iSeries query definition . . . . . . . . . . . . . . . . . . . . 167
Describing the Query for iSeries query definition
. . . . . . . . . . . . . . . . . . 168
Giving authority to others to your Query for iSeries query . . . . . . . . . . . . . . . 168
Running a Query for iSeries query . . . . . . . . . . . . . . . . . . . . . . . . . . 169
24 Query for iSeries Use V5R2