SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-16
LINE_SPACING Option
LINE_SPACING Option
LINE_SPACING is an option of the SQLCI report writer SET LAYOUT command that
specifies how many lines to advance between report lines.
LINE_SPACING also defines the increment of the SKIP clause. For example, if you set
the LINE_SPACING option to 2 and specify SKIP 3 as a print item in a print list, the
report writer skips six (2*3) lines before printing the next report line.
number
is an integer in the range 1 through 32,767 that specifies how many lines to
advance before printing the next report line.
Examples—LINE_SPACING

This example sets double spacing:
>> SET LAYOUT LINE_SPACING 2;

This example sets triple spacing and page length 62:
>> SET LAYOUT PAGE_LENGTH 62, LINE_SPACING 3;
LIST Command
LIST is an SQLCI report writer command that displays rows returned by the SELECT
command. You can use LIST only from the select-in-progress prompt (S>).
F[IRST] [number]
displays the first number rows of the result table and then returns to the
select-in-progress prompt. If you omit number, SQL uses the current value of the
LIST_COUNT session option. (The default for the LIST_COUNT session option is
ALL; you can change it with the SET SESSION command.)
N[EXT] [number]
displays the next number rows of the result table and then returns to the
select-in-progress prompt (S>).
LINE_SPACING number
The default is 1. (Single spacing)
{ { F[IRST] } [number] }
{ { N[EXT] } }
L[IST] { } ;
{ A[LL] }