ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-87
WHERE Clause
correlation-name
is a name that identifies the table or view for the SELECT statement. Each
correlation-name in the FROM clause must be unique.
In SQL Server, a correlation name is called an alias.
HOLDLOCK
in SQL Server, this makes a shared lock on a specified table or view more
restrictive by holding it until the completion of a transaction.
In the NonStop ODBC Server, the HOLDLOCK keyword determines the locking
mode for the SELECT statement as follows:
WHERE Clause
The WHERE clause of the SELECT statement specifies a search condition to be
applied to each row of the FROM clause result table and has the following syntax:
Search conditions are described under Language Elements on page 4-5.
GROUP BY Clause
The GROUP BY clause of the SELECT statement specifies the groups into which the
table will be divided and has the following syntax:
ALL
is not supported. In the NonStop ODBC Server, ALL is ignored.
HOLDLOCK present? Locking Mode Used
Yes The NonStop SQL/MP REPEATABLE ACCESS mode,
which retains locks on all rows that are read, keeping the
data locked once it is accessed. Locks are released when
the transaction is committed or aborted.
No The NonStop SQL/MP STABLE ACCESS, which locks data
for a short duration; data is locked and remains locked only
while it is being processed.
WHERE search-condition
GROUP BY [ ALL ] agg-free-expr [ , agg-free-expr ] ...
agg-free-expr is:
{ column-name }
{ expression }