IBM SC41-5210-04 manual Length and decimal positions in Query for iSeries reports, Lastname Init

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:

vFor SBCS character fields, length is the total number of characters in the field.

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

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

vFor 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).

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

v0 through 32 766 for SBCS character fields

v0 through 31 for numeric fields in packed, zoned, or binary form

120Query for iSeries Use V5R2