NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-15
Examples—LINE_SPACING
LINE_SPACING also defines the increment of the SKIP clause. For example, if you set
the LINE_SPACING option to 2 and then 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
•
The following example sets double spacing:
>> SET LAYOUT LINE_SPACING 2;
•
The following 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>).
If you omit number, SQL uses the current value of the LIST_COUNT session
option.
Using LIST NEXT without number is equivalent to pressing the return key at the
S> prompt.
LINE_SPACING number
The default is 1. (Single spacing)
{ { F[IRST] } [number] }
{ { N[EXT] } }
L[IST] { } ;
{ A[LL] }