SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-230
UPDATE Statement
described above for expression apply to each array element in the rowset-
expression.
For details on using host variables and rowsets, see the SQL/MX
Programming Manual for C and COBOL.
WHERE search-condition
specifies a search-condition that selects rows to update. Within the
search-condition, columns being compared are also being updated in the
table or view. See Search Condition on page 6-102.
If you do not specify a search-condition, all rows in the table or view are
updated.
Do not use an UPDATE statement with a WHERE clause that contains a SELECT
for the same table. Reading from and inserting into, updating in, or deleting from
the same table generates an error. Use a positioned (WHERE CURRENT OF)
UPDATE instead.
WHERE rowset-search-condition
specifies an array of search conditions that selects rows to delete. The search
conditions are applied successively and rows selected by each condition are
updated before the next search condition is applied. Therefore, a single row can be
updated multiple times. You can use a rowset expression in the set clause only if a
rowset search condition is present. See Rowset Search Condition on
page 6-104.
[FOR] access-option ACCESS
specifies the access-option required for data used in the evaluation of a search
condition. See Data Consistency and Access Options on page 1-7.
READ COMMITTED
specifies that any data used in the evaluation of the search condition must be
from committed rows.
SERIALIZABLE | REPEATABLE READ
specifies that the UPDATE statement and any concurrent process (accessing
the same data) execute as if the statement and the other process had run
serially rather than concurrently.
SKIP CONFLICT
enables transactions to skip rows locked in a conflicting mode by another
transaction. The rows under consideration are the result of evaluating the
search condition for the UPDATE statement. SKIP CONFLICT cannot be used
in a SET TRANSACTION statement.
Embed