IBM ISERIES SC41-5210-04 User Manual
Page 203
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