Filter
Top Products
If you want to increase the left margin of the report (with the left edge being print position 1), go to the
Specify Report Column Formatting display and type a larger value in the Column Spacing prompt for
the first field to be shown in the report.
Note: For DBCS-graphic fields, Query adds DBCS shift-out and shift-in characters before showing the
fields in a displayed or printed report. Variable-length DBCS values are extended to the full field
length.
Start line in Query for iSeries reports
Type a number 1 through 255 that indicates the first line to be printed on each page of your report.
Depending on what you have defined elsewhere in this query definition, the first line of page headings,
column headings, or the next record is printed on this starting line.
If you leave this prompt blank, the starting line is line 6. If you specify a starting line number, it must be no
greater than the ending line value and less than or equal to the form length value.
End line in Query for iSeries reports
Type a number 1 through 255 that indicates the last line to be printed on each page of your report.
Depending on what you have defined elsewhere in this query definition, the page footing or a record (or
part of a record, if it is wrapped) is printed on this ending line. If you specify an ending line number, it must
be greater than the starting line value and less than or equal to the form length value. If the ending line is
greater than the form length, Query prints the report using an ending value equal to the form length value.
If you leave this prompt blank, the value specified in the printer device file (named QPQUPRFIL) used by
Query determines the ending line number.
Line spacing in Query for iSeries reports
Type a number (1, 2,or3) that indicates the kind of line spacing between records that you want used for
your report. This value controls the amount of separation (blank lines) between all but wrapped lines,
which are always single spaced. A value of 2 or 3 can make the report easier to read if line wrapping is
active and required. A default value of 1 is assumed, and a single-spaced report is printed.
1 Prints with single-spacing (no blank lines between)
2 Prints with double-spacing (one blank line between)
3 Prints with triple-spacing (two blank lines between)
Print definition in Query for iSeries reports
Type a Y or N to indicate whether you want a copy of your query definition to be printed whenever the
query report is printed. N (No) is the default.
Y=Yes
A copy of the query definition is to be printed along with the query report. The definition is printed
immediately ahead of the report.
N=No
A copy of the query definition is not to be printed when the report is printed.
Specifying spooled output overrides in Query for iSeries reports
The Define Spooled Output display is another printer output definition display used to continue defining the
print characteristics of your query report. You can specify the type of forms (paper) to be used in the
printer and the number of copies of your report to be printed. You can also specify the spooling
characteristics: whether the output is to be spooled, and whether it is to be held on the output queue to be
printed at a later time.
If you specified that both the query report and query definition are to be printed, the values on this display
apply to both of them.
150 Query for iSeries Use V5R2