ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-91
NonStop ODBC Server Compared With
NonStop SQL/MP
When used through the NonStop ODBC Server, SELECT differs from the NonStop
SQL/MP implementation in the following ways:
IN EXCLUSIVE MODE Clause
In programs used with the NonStop ODBC Server, you cannot specify the NonStop
SQL/MP IN EXCLUSIVE MODE clause; you can, however, obtain exclusive mode by
locking the table using pass-through mode as shown in the following example:
begin transaction
use test_disk01_persnl
select "tdm: sql lock table \test.$disk01.persnl.employee
in exclusive mode"
select jobcode, deptnum, first_name, last_name
from employee
where jobcode > 500 and deptnum <= 3000"
select "tdm: sql unlock table \test.$disk01.persnl.employee"
commit transaction
Remember to unlock the table when you no longer need the lock on it, as illustrated in
the preceding example.
In a program used with NonStop SQL/MP, you would obtain exclusive mode by
specifying the IN EXCLUSIVE MODE clause:
select jobcode, deptnum, first_name, last_name
from persnl.employee
where jobcode > 500 and deptnum <= 3000
in exclusive mode;
Feature In NonStop SQL/MP
In Programs Used With the
NonStop ODBC Server
How to specify the
locking mode
Use the
BROWSE/REPEATABLE/
STABLE ACCESS clause.
Use the HOLDLOCK keyword; you
cannot use the
BROWSE/REPEATABLE/STABLE
ACCESS clause.
Is BROWSE ACCESS
locking mode available?
Yes No, unless you use pass-through
mode.
Is the INTO clause
available?
Yes No, unless you use pass-through
mode.
Is the IN EXCLUSIVE
MODE clause
available?
Yes No, unless you use pass-through
mode.
See IN EXCLUSIVE MODE Clause
.
Is the UNION clause
available?
Yes No, unless you use pass-through
mode.