NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
W-3
Considerations—WINDOW
TAB number
specifies an integer in the range 1 through 255 that is the print position of the output
line to display at the left edge of the output device. (The first position in the output
line is 1, and each print position occupies one byte.) The default is TAB 1.
You can use this clause at the select-in-progress prompt (S>) or at the standard
SQLCI prompt (>>).
column
identifies a print item in the detail print list to begin printing at the left edge of the
output device. column can be a column name, an alias, or COL number (which
specifies the position of the column in the select list). column cannot be a detail
alias.
You can use this clause only at the select-in-progress prompt (S>).
If you specify a column that is not in the detail print list, the report writer ignores the
WINDOW command. If the column appears in the detail print list more than once,
its first occurrence is the one that prints at the left edge of the output device.
Considerations—WINDOW
•
WINDOW with column identifier is reset after SELECT
If WINDOW is set to a column identifier (as opposed to a TAB position) when a
SELECT command terminates, the report writer resets WINDOW to TAB 1.
Examples—WINDOW
•
The following example defines a report format for the rows specified in the
SELECT command at the beginning of the example. The WINDOW option of the
SET LAYOUT command specifies that only the rightmost portion of the report
(beginning at print position 40) should be displayed when the LIST command
executes.
>> SELECT EMPNUM, LAST_NAME, SALARY, SALARY * .05
+> FROM PERSNL.EMPLOYEE;
S> NAME COL 4 BONUS;
S> DETAIL "*", EMPNUM, LAST_NAME, SALARY, SALARY * 1.1 NAME
+> NEW_SALARY, BONUS;
S> SET LAYOUT WINDOW TAB 40;
S> LIST;
•
The following SET LAYOUT commands use the WINDOW option to specify
different vertical segments of the report defined in the previous example. (You could
use any one in place of the previous SET LAYOUT command.) As in that example,