ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-89
COMPUTE BY Clause
ASC or DESC
specifies whether to sort in ascending or descending order; the default is
ascending.
COMPUTE BY Clause
The COMPUTE BY clause of the SELECT statement is not supported in the NonStop
ODBC Server. It has the following syntax:
Inclusion of the COMPUTE BY clause causes an error message to be generated.
FOR BROWSE Clause
The FOR BROWSE clause of the SELECT statement is not supported in the NonStop
ODBC Server. It has the following syntax:
The FOR BROWSE clause is ignored, and the SELECT statement is executed without
browse access. No messages or warnings are generated.
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, SELECT differs from the SQL Server
implementation in the following ways:
COMPUTE comp-list BY column-name [ , column-name ] ...
comp-list is:
aggregate(column-name) [, aggregate(column-name) ] ...
FOR BROWSE
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server
Is the INTO clause
available?
Yes No, but an alternative is
available.
See INTO Clause
on page 4-90.
Is SQL Server BROWSE
mode available?
Yes No
Is the COMPUTE BY
clause available?
Yes No
Locking mode used Shared, unless you specify
the HOLDLOCK keyword—
then the shared lock is more
restrictive.
NonStop SQL/MP STABLE
ACCESS, unless you specify the
HOLDLOCK keyword—then
REPEATABLE ACCESS is used.