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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-111
DELETE Statement
set-roll-clause
sets the specified column to a particular value. For each set-roll-clause,
the value of the specified target column-name is replaced by the value of the
update source expression. The data type of each target column must be
compatible with the data type of its source value.
column-name
names a column in table to update. You cannot qualify or repeat a
column name. You cannot update the value of a column that is part of the
primary key.
expression
is an SQL value expression that specifies a value for the column. The
expression cannot contain an aggregate function defined on a column.
The data type of expression must be compatible with the data type of
column-name. A scalar subquery in expression cannot refer to the
table being updated.
If expression refers to columns being updated, NonStop SQL/MX uses
the original values to evaluate the expression and determine the new
value.
See Expressions on page 6-37.
WHERE search-condition
specifies a search condition that selects rows to delete. Within the search
condition, any columns being compared are columns in the table or view being
deleted from. See Search Condition on page 6-102.
If you do not specify a search condition, all rows in the table or view are deleted.
You can also delete all the rows from a table or a partition of a table by using the
PURGEDATA utility.
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
deleted before the next search condition is applied. See Rowset Search Condition
on page 6-104.
[FOR] access-option ACCESS
specifies the access option required for data used in the evaluation of the 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
come from committed rows.
Embed