NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
W-2
Considerations—WHENEVER Directive
host-id is an identifier that specifies a location in the host language program. For
more information, see the NonStop SQL/MP programming manual for your host
language.
If you do not specify an action, SQL discontinues checking for the specified
condition.
Considerations—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. See the entries for
the SELECT Statement
on page S-18, DELETE Statement on page D-37, or UPDATE
Statement on page U-3 for more information.
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-37, 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.
GO TO :host-id pass control to location host-id
CALL :host-id execute host-id (Not COBOL85)
PERFORM :host-id execute host-id (COBOL85 only)
WINDOW { TAB number }
{ column }
CONTINUE
continue with next statement