ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-81
NonStop ODBC Server Compared With SQL Server
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, ROLLBACK TRANSACTION differs
from the SQL Server implementation in the following ways:
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is ROLLBACK WORK.
The primary difference between NonStop ODBC Server transactions and NonStop
SQL/MP transactions is that, in programs used with the NonStop ODBC Server, you
can specify a transaction name. The transaction name is provided primarily for
compatibility with SQL Server and is not meaningful in NonStop SQL/MP (transactions
cannot be nested in NonStop SQL/MP).
SAVE TRANSACTION
Use SAVE TRANSACTION to set a transaction savepoint. If used in the NonStop
ODBC Server, the SAVE TRANSACTION statement is ignored. No error or warning
messages are generated.
The SAVE TRANSACTION statement has the following syntax:
savepoint-name
is not supported. This parameter is ignored.
Examples
The following transaction contains several savepoints:
use test_disk01_persnl
begin transaction
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server
Are nested transactions
allowed?
Yes No
Transaction savepoints allowed? Yes Yes, but they are ignored. If you
want to roll back a transaction, you
must roll back the entire
transaction.
Are DDL operations on a table
allowed within a user-defined
transaction?
No Yes, if the table is audited.
See DDL Statements Allowed in
User-Defined Transactions on
page 4-3.
SAVE TRAN[SACTION] [ savepoint-name ]