IBM SC41-5210-04 Start line in Query for iSeries reports, End line in Query for iSeries reports

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, or 3) 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.

1Prints with single-spacing (no blank lines between)

2Prints with double-spacing (one blank line between)

3Prints 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.

150Query for iSeries Use V5R2