IBM ISERIES SC41-5210-04 User Manual

Page 203

Advertising

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__________________________ ____________________

_________________________________ ____________________

RESULT295_ PRN299B__________________________ ____________________

_________________________________ ____________________

RESULTA___ RESULT269/RESULT295______________ ____________________

_________________________________ ____________________

Bottom

_______________________________________________________________________________

Field

Text

Len Dec

PRN299A

Field with precision of 29,9

PRN299B

Field with precision of 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

Advertising