IBM SC41-5210-04 Server User Manual


 
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