ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-98
NonStop ODBC Server Compared With
NonStop SQL/MP
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is UPDATE.
When used through the NonStop ODBC Server, UPDATE differs from the NonStop
SQL/MP implementation in the following ways:
UPDATE STATISTICS
Use UPDATE STATISTICS to update all statistics associated with all columns of a
specified table.
The UPDATE STATISTICS statement has the following syntax:
table-name
identifies the table for which statistics are to be updated; table-name can be
qualified with the database name and owner name.
index-name
is not supported. If included in a program used with the NonStop ODBC Server, the
index-name is ignored.
Examples
The following statement updates statistics on the EMPLOYEE table:
use test_disk01_persnl
update statistics
employee
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
UPDATE STATISTICS
[ [database.]owner. ] table-name [ index-name ]