ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-60
CORE SQL Compared With NonStop SQL/MP
SELECT in CORE SQL 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 work
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.
Feature In NonStop SQL/MP In CORE SQL
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 the following discussion of
“IN EXCLUSIVE MODE Clause.”