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

Part 3. Advanced information about Query for iSeries
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
Addition and subtraction in Query for iSeries . . . . . . . . . . . . . . . . . . . . 189
Multiplication in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . 189
Division 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
© Copyright IBM Corp. 2000, 2002 185