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

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
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
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
Running a Query for iSeries query . . . . . . . . . . . . . . . . . . . . . . . . . . 169
Using function key F5 when running a Query for iSeries query . . . . . . . . . . . . . . 169
Running a Query for iSeries query from the Query for iSeries menu . . . . . . . . . . . . 169
Running a Query for iSeries query from the Exit This Query display
. . . . . . . . . . . . 169
Running a Query for iSeries query from the Work with Queries display . . . . . . . . . . . 170
Running a Query for iSeries query using the RUNQRY command . . . . . . . . . . . . . 171
Chapter 16. Working with Query for iSeries query definitions . . . . . . . . . . . . . . 173
Changing a Query for iSeries query definition. . . . . . . . . . . . . . . . . . . . . . 173
Starting changes by copying a Query for iSeries query definition . . . . . . . . . . . . . 173
Changes you can make to a Query for iSeries query . . . . . . . . . . . . . . . . . . 173
Considerations for changing Query for iSeries queries
. . . . . . . . . . . . . . . . . 176
Copying a Query for iSeries query definition . . . . . . . . . . . . . . . . . . . . . . 177
Renaming a Query for iSeries query definition
. . . . . . . . . . . . . . . . . . . . . 178
Deleting a Query for iSeries query definition . . . . . . . . . . . . . . . . . . . . . . 178
Displaying a Query for iSeries query definition . . . . . . . . . . . . . . . . . . . . . 179
Printing a Query for iSeries query definition . . . . . . . . . . . . . . . . . . . . . . 180
Information printed for a Query for iSeries query definition . . . . . . . . . . . . . . . . 181
Example of printed record format information for a Query for iSeries query definition . . . . . . 182
Part 3. Advanced information about Query for iSeries . . . . . . . . . . . . 185
Chapter 17. Additional information about Query for iSeries for programmers . . . . . . . . 187
Files with different record formats in Query for iSeries
. . . . . . . . . . . . . . . . . . 187
File sharing considerations in Query for iSeries . . . . . . . . . . . . . . . . . . . . . 187
Overriding database files in Query for iSeries. . . . . . . . . . . . . . . . . . . . . . 187
DBCS considerations when defining result fields in Query for iSeries . . . . . . . . . . . . . 187
Joining files in Query for iSeries
. . . . . . . . . . . . . . . . . . . . . . . . . . 188
Using *ALL in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . . 188
Using fields other than sort fields for report breaks in Query for iSeries . . . . . . . . . . . . 188
Result field length and decimal positions in Query for iSeries . . . . . . . . . . . . . . . . 188
Tips for dealing with presentation length and decimal positions in Query for iSeries. . . . . . . 188
Length and decimal positions used for internal numeric calculations in Query for iSeries . . . . . 189
Example: Increasing the decimal precision for result fields in Query for iSeries
. . . . . . . . 190
Selecting records (ignoring field case) in Query for iSeries . . . . . . . . . . . . . . . . 191
Part 4. Appendixes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193
vi Query for iSeries Use V5R2