ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-62
Searched UPDATE
cursor-name
specifies the cursor for which the active row is to be changed. The cursor
specification for cursor-name must include the FOR UPDATE clause and the
result table of the cursor must be updatable.
Searched UPDATE
The searched UPDATE statement has the following syntax:
table-name
is the table in which rows are to be changed. The table-name can be qualified
with the database name and owner name. If table-name is a viewed table,
UPDATE changes the corresponding row of the base table from which the viewed
table is derived.
The table-name must be the (single) table referenced by the FROM clause of the
query-specification that defines the result table of the cursor.
column-identifier
specifies a column in which a row is to be changed.
expression
is a valid expression to be assigned. Expressions are described under Language
Elements on page 3-2.
NULL
sets the value to NULL.
search-condition
specifies criteria for selecting the rows to be updated.
The search-condition cannot have a subquery that references the table or
view in which the rows are being updated.
UPDATE table-name
SET column-identifier = { expression }
{ NULL }
[, column-identifier = { expression } ] ...
{ NULL }
WHERE CURRENT OF search-condition