ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-64
NonStop ODBC Server Compared With SQL Server
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, DELETE differs from the SQL Server
implementation in the following ways:
FROM Clause
In programs used with the NonStop ODBC Server, you cannot specify the SQL Server
FROM clause with the DELETE statement. You can, however, sometimes achieve the
same results by using a subquery.
The following DELETE statement is used with the NonStop ODBC Server. It deletes
employees that work for manager number 1001. The statement uses a subquery to
select all departments for which the manager is number 1001:
delete test_disk01_persnl..employee
where deptnum in
(select deptnum from dept where manager = 1001)
In a program used with SQL Server, you could execute the previous statement by
using a FROM clause:
delete employee
from dept
where employee.deptnum = dept.deptnum and dept.manager = 1001
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is DELETE.
When used through the NonStop ODBC Server, DELETE differs from the NonStop
SQL/MP implementation in the following ways:
Feature In SQL Server
In Programs Used With the NonStop ODBC
Server
Is the FROM
clause available?
Yes No. If you use it, the NonStop ODBC Server
generates an error message.
See the following discussion of the FROM clause.
Locking mode used Exclusive The NonStop SQL/MP REPEATABLE ACCESS
mode, which is functionally similar to the SQL
Server default of exclusive mode.
Feature In NonStop SQL/MP
In Programs Used With the NonStop
ODBC Server
Can you specify the
locking mode?
Yes No, unless you use pass-through mode.
Default locking mode STABLE ACCESS REPEATABLE ACCESS