IBM SC41-5210-04 manual Query for iSeries result field name, Query for iSeries expressions

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:

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

vDo 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:

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

vA date expression performs an operation on a date. Date expressions can contain the following operators or functions:

+ (Addition)

−(Subtraction)

CHAR DATE

58Query for iSeries Use V5R2