SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-189
SELECT Statement
:array-name [,:array-name]...
specifies a set of host variable arrays. Each array-name can be used like a
column in the rowset-derived table. Each array-name can be any valid host
language identifier with a data type that corresponds to an SQL data type.
Precede each array-name with a colon (:) within an SQL statement.
For more information on rowsets and host variable arrays, see the SQL/MX
Programming Manual for C and COBOL.
WHERE search-condition
specifies a search-condition for selecting rows. See Search Condition on
page 6-105. The WHERE clause cannot contain an aggregate (set) function.
The search-condition is applied to each row of the result table derived from
the table reference in the FROM clause or, in the case of multiple table references,
the cross-product of result tables derived from the individual table references.
Each column you specify in search-condition is typically a column in this
intermediate result table. In the case of nested subqueries used to provide
comparison values, the column can also be an outer reference. See Subquery on
page 6-108.
To comply with ANSI standards, NonStop SQL/MX does not move aggregate
predicates from the WHERE clause to a HAVING clause and does not move
non-aggregate predicates from the HAVING clause to the WHERE clause, as
NonStop SQL/MP does.
WHERE rowset-search-condition
specifies a rowset-search-condition for selecting rows. See Rowset Search
Condition on page 6-107. The WHERE clause cannot contain an aggregate (set)
function. The individual search conditions in rowset-search-condition are
applied successively to the result table derived from the table reference in the
FROM clause or, in the case of multiple table references, the cross-product of
result tables derived from the individual table references. A row that matches any
one of the individual search conditions is selected. If a row matches multiple
search conditions, it is selected only once.
Each column you specify in rowset-search-condition is typically a column in this
intermediate result table. In the case of nested subqueries used to provide
comparison values, the column can also be an outer reference. See Subquery on
page 6-108.
Embed