Filter
Top Products
always appears below and to the right of the list to tell you where you are in the list. More... means that
there are more items after, and possibly before, the items currently shown. Bottom means that you are at
the end of the list, but there may be more items before those currently shown.) Use F19 (Next group) to
reposition the list at the beginning of the next logical group of fields (the cursor can be anywhere when
you use F19). (The first group is selected fields, if any, and the second group is sort fields, if any. If there
are not selected fields, then the fields are grouped by file, and within each file grouping, the fields are
listed in the order in which they appear in the file definition.)
You can specify the length and number of decimal positions for a numeric result field by filling in the Len
and Dec prompts on this display, or you can have Query determine the length and decimal positions for
you by leaving the prompts blank.
You can specify a column heading for any result field. If you leave the prompt blank, the result field name
is used as the column heading for the result-field definition.
Query for iSeries result field name
Since Query result field names are similar to database field names, create them according to the following:
v Start the name with an alphabetic character (A through Z, $, #, or @) and use no more than 9
alphanumeric characters (A through Z, 0 through 9, $, #, @, or _) for the remaining characters. Do not
use blanks within the name.
Note: Use A-Z or 1-9 if this query is sent to other systems or used in a multilingual environment.
v Do not use any names from the list on the lower part of the display or the names of other result fields.
Enter an expression that creates the desired value for your result field.
Query for iSeries expressions
In Query for iSeries, an expression is a representation of a value with field names, constants, functions,
or keywords appearing alone or in combination with operators. It can be either a numeric, character
(SBCS or DBCS), date, time or timestamp expression:
v A numeric expression assigns numbers or performs an operation (calculation) on them. Numeric
expressions can contain the following operators:
+ (Addition)
− (Subtraction)
* (Multiplication)
/ (Division)
v A character expression assigns characters or performs an operation on them. Character expressions
can contain the following operators or functions:
|| (Concatenation operator)
SUBSTR (Substring function)
VALUE (Value function)
DIGITS (Digits function)
Note: See “CCSID and result field expressions in Query for iSeries” on page 252 to see how CCSIDs
are handled for the concatenation symbol.
v A date expression performs an operation on a date. Date expressions can contain the following
operators or functions:
+ (Addition)
− (Subtraction)
CHAR
DATE
58 Query for iSeries Use V5R2