IBM SC41-5210-04 manual Selecting records ignoring field case in Query for iSeries

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

Selecting records (ignoring field case) in Query for iSeries

To select records ignoring the case, do one of the following:

vDefine your own collating sequence such that uppercase and lowercase letters have the same weight.

vUse 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.

Chapter 17. Additional information about Query for iSeries for programmers 191