SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-14
Supported SQL Statements
UNREGISTER CATALOG
statement
Removes an empty catalog
reference from a node.
See Data Definition
Language (DDL)
Statements on
page 4-32.
UPDATE statement and
positioned UPDATE statement
Updates values in columns of a
table or view. A positioned
UPDATE statement with the
WHERE CURRENT OF clause
is used in a data retrieval loop
for an iterator.
See Example—
UPDATE Statement
on page 3-29.
For a positioned
UPDATE statement,
see Positioned
UPDATE and
DELETE Statements
on page 3-55.
UPDATE STATISTICS statement Updates the histogram statistics
for one or more groups of
columns within a table to
enable optimized access plans.
See UPDATE
STATISTICS
Statement on
page 4-39.
Table A-1. Embedded SQL/MX Statements (page 7 of 7)
SQL Statement Description More Information
The ANSI icon indicates a statement that complies with the ANSI standard. All other statements in this table are
SQL/MX extensions.
ANSI