SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
W-2
Consideration—WHENEVER Directive
If you do not specify an action, SQL discontinues checking for the specified
condition.
Consideration—WHENEVER Directive
The WHENEVER directive applies to source lines of a program that are sequentially
compiled (including text brought in by SOURCE, COPY, and INLINE directives) The
directive stays in effect until SQL detects another WHENEVER directive for the same
condition.
WHERE CLAUSE
WHERE clauses on SELECT, DELETE, or UPDATE statements are search condition
clauses that specify criteria for choosing rows from tables or views. For more
information, see SELECT Statement on page S-18, DELETE Statement on page D-39,
or UPDATE Statement on page U-3.
WHERE clauses on SQLCI utility commands qualify the set of files on which the
command is to operate.
For examples of the WHERE clause, see Qualified Fileset List on page Q-1 and topics
for other language elements related to the WHERE clause, such as SELECT
Statement on page S-18, DELETE Statement on page D-39, UPDATE Statement on
page U-3, and EXISTS Predicate on page E-12.
WINDOW OPTION
WINDOW is an option of the SQLCI report writer SET LAYOUT command that
specifies a print item or print position to display at the left edge of the output device. It
enables you to display the portion of a report that extends beyond the right edge of the
output device.
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
WINDOW { TAB number }
{ column }