IBM SC41-5210-04 manual Selecting sort fields in Query for iSeries

Numeric constants as values in Query for iSeries	.	94
Date, time, timestamp constants as values in Query for iSeries	.	95
Null values in Query for iSeries	.	95
Comparison tests in Query for iSeries	.	95
Date, time, or timestamp comparisons in Query for iSeries	.	96
Testing for equal (EQ) and not equal (NE) in Query for iSeries	.	96
Testing for IS Null (IS) and ISNOT Null (ISNOT) in Query for iSeries	.	96
Testing for greater (GT or GE), less (LT or LE), and range (RANGE) in Query for iSeries . . .	.	96
Testing for values in a list (LIST NLIST) in Query for iSeries	.	97
Testing for values that are similar (LIKE NLIKE) in Query for iSeries	.	98

Testing for DBCS LIKE (like) and NLIKE (not like) in Query for iSeries . . . . . . . . . . . 99 Using more than one comparison test in Query for iSeries . . . . . . . . . . . . . . . . 101 Adding and removing comparisons in Query for iSeries . . . . . . . . . . . . . . . . . 103

Chapter 8. Selecting sort fields in Query for iSeries	. .	. .	.	. . . . 105
Letting Query for iSeries determine the order of records for you	. .	. .	.	. . . . 105
Selecting the sort fields you want to use in Query for iSeries	. .	. .	.	. . . . 105
Additional sort considerations in Query for iSeries	. .	. .	.	. . . . 108
Chapter 9. Selecting a collating sequence in Query for iSeries	. .	. .	.	. . . . 111
Letting Query for iSeries select a collating sequence	. .	. .	.	. . .	.	111
Setting your default collating sequence in Query for iSeries	. .	. .	.	. . .	.	111
Purpose of a collating sequence in Query for iSeries	. .	. .	.	. . .	.	111
Collating sequence and CCSIDs in Query for iSeries	. .	. .	.	. . . . 112
How a collating sequence affects Query for iSeries	. .	. .	.	. . . . 112
Selecting a Query for iSeries collating sequence	. .	. .	.	. . . . 113
Using the hexadecimal collating sequence in Query for iSeries	. .	. .	.	. . . . 113
Using the language collating sequence for your country in Query for iSeries	. .	. .	.	. . . . 114
Defining your own collating sequence in Query for iSeries	. .	. .	.	. . . . 115
Selecting a translation table in Query for iSeries	. .	. .	.	. . . . 116
Selecting a system sort sequence in Query for iSeries	. .	. .	.	. . . . 117
Chapter 10. Specifying report column formatting in Query for iSeries . .	. .	. .	.	. . . . 119
Formatting the columns of the Query for iSeriesquery report	. .	. .	.	. . . . 119
Column spacing in Query for iSeries reports	. .	. .	.	. . . . 119
Column headings in Query for iSeries reports	. .	. .	.	. . . . 119
Length and decimal positions in Query for iSeries reports	. .	. .	.	. . . . 120
Omitting fields from a Query for iSeries report	. .	. .	.	. . . . 121
Editing numeric fields in Query for iSeries reports	. .	. .	.	. . . . 122
Defining numeric field editing in Query for iSeries reports	. .	. .	.	. . . . 122
Describing numeric field editing in Query for iSeries reports	. .	. .	.	. . . . 124
Decimal point in Query for iSeries reports	. .	. .	.	. . . . 125
Thousands separator in Query for iSeries reports	. .	. .	.	. . . . 125
Show negative sign in Query for iSeries reports	. .	. .	.	. . . . 125
Left negative sign in Query for iSeries reports	. .	. .	.	. . . . 125
Right negative sign in Query for iSeries reports	. .	. .	.	. . . . 126
Show currency symbol in Query for iSeries reports	. .	. .	.	. . . . 126
Left currency symbol in Query for iSeries reports	. .	. .	.	. . . . 126
Right currency symbol in Query for iSeries reports	. .	. .	.	. . . . 126
Print zero value in Query for iSeries reports	. .	. .	.	. . . . 127
Replace leading zeros in Query for iSeries reports	. .	. .	.	. . . . 127
Replace with option in Query for iSeries reports	. .	. .	.	. . . . 127
Single leading zero in Query for iSeries reports	. .	. .	.	. . . . 127
Describing date/time field editing display in Query for iSeries reports . . .	. .	. .	.	. . . . 127
Date/time separator in Query for iSeries reports	. .	. .	.	. . . . 128
Specifying an edit code in Query for iSeries reports	. .	. .	.	. . .	.	129

Part 2. Defining and using Query for iSeries query definitions 23