Filter
Top Products
Each column heading appears in the report exactly as you type it. Each heading can be up to three
20-character lines, and you can use any characters you want (see the heading for the INIT field on the
following display).
Specify Report Column Formatting
Type information, press Enter.
Column headings: *NONE, aligned text lines
Column
Field Spacing Column Heading Len Dec Edit
LASTNAME 0 LASTNAME 30
INIT 2 First & 2
Middle
Initials
STARTTIME 2 6 *
Start
Time
Bottom
F3=Exit F5=Report F10=Process/previous F12=Cancel
F13=Layout F16=Edit F18=Files F23=Long comment
If you want the headings of all your columns to line up on the lowest heading line, you must type each one
on the display that way.
If you change a heading but decide you want to use the original heading, blank out the heading you typed.
The original (default) heading is used in the report and appears the next time you return to this display. If
you want to change the heading for a result field, you may change it on the Define Result Fields display,
as described in Chapter 5, “Defining result fields in Query for iSeries”.
Length and decimal positions in Query for iSeries reports
The length first shown for each field from a file is the length defined in the field definition. The length first
shown for each result field is the length that Query calculates for you, or is the value that you typed in the
Len column on the Define Result Fields display. Length has a different meaning for each data type:
v For SBCS character fields, length is the total number of characters in the field.
v For DBCS-only, DBCS-open, or DBCS-either fields, length is the total number of bytes in the field,
including shift-out and shift-in characters.
v For DBCS-graphic fields, length is the total number of DBCS characters in the field. Shift-out and shift-in
characters used when the field is displayed or printed are not included in the Len value.
v For numeric fields, length is the number of digits to the left and right of the decimal point, but does not
include the decimal point or any other editing characters (like a currency symbol).
v For date, time, and timestamp fields, the length is the number of characters in the formatted value,
including the separators and any other characters required by the format (for example, 12:15 am).
Timestamp is always 26 characters long.
Changing the Len value on this display affects only how the field appears in this query. The actual length
is not changed in the field definition, and the actual length is used for all other field processing done by
Query, such as sorting, report breaks, and so on. If you want to change the actual length for a result field,
you should make the changes on the Define Result Fields display rather than during formatting.
If you specify a length, the valid length values are:
v 0 through 32 766 for SBCS character fields
v 0 through 31 for numeric fields in packed, zoned, or binary form
120 Query for iSeries Use V5R2