ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-63
Example
Example
The following example updates the salary of employee number 1002:
update test_disk01_persnl..employee
set salary = salary * 1.1
where empnum = 1002
CORE SQL Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is UPDATE.
UPDATE in CORE SQL differs from the NonStop SQL/MP implementation in the
following ways:
Feature In NonStop SQL/MP In CORE SQL
Can you specify the locking
mode?
Yes No, unless you use pass-through
mode.
Default locking mode STABLE ACCESS REPEATABLE ACCESS