Filter
Top Products
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