Filter
Top Products
Selecting records (ignoring field case) in Query for iSeries
To select records ignoring the case, do one of the following:
v Define your own collating sequence such that uppercase and lowercase letters have the same weight.
v Use a system sort sequence with shared collating weights.
You must also set the Use collating sequence for all character comparisons option in the Select
Processing Options display to YES. If for some reason you cannot set this option, you will have to use an
EQ (equal) test alternative such as RANGE or a combination of LE (less than or equal) and GE (greater
than or equal). (This works only if there is no DBCS data involved.)
Note: Changing your collating sequence affects sorting, minimum, maximum, and report breaks. See
“CCSID conversions for Query for iSeries options and functions” on page 249 for more information
about how CCSIDs affect sorting, minimum, maximum, and report breaks.
Define Result Fields
Type definitions using field names or constants and operators, press Enter.
Operators: +, -, *, /, SUBSTR, ||, DATE...
Field Expression Column Heading Len Dec
RESULT269_ PRN299A__________________________ ____________________ 26 _9
_________________________________ ____________________
_________________________________ ____________________
RESULT295_ PRN299B__________________________ ____________________ 29 _5
_________________________________ ____________________
_________________________________ ____________________
RESULTA___ RESULT269/RESULT295______________ ____________________ __ __
_________________________________ ____________________
_________________________________ ____________________
Bottom
_______________________________________________________________________________
Field Text Len Dec
PRN299A Field with precision of 29,9 29 9
PRN299B Field with precision of 29,9 29 9
Bottom
F3=Exit F5=Report F9=Insert F11=Display names only
F12=Cancel F13=Layout F20=Reorganize F24=More keys
Figure 6. Changing Decimal Precision
Chapter 17. Additional information about Query for iSeries for programmers 191