Neoview SQL Reference Manual (R2.5)

TRANSACTION statement to enable the NO ROLLBACK option for the transaction. See
“SET TRANSACTION Statement” (page 188).
An error message is generated if one of the following is true:
• WITH NO ROLLBACK used with STREAM clause
• WITH NO ROLLBACK used with SET ON ROLLBACK clause
table
names the user table or view from which to delete rows. table must be a base table or an
updatable view. To refer to a table or view, use the ANSI logical name:
See “Database Object Names” (page 242).
STREAM (table)
deletes a continuous data stream from the specified table. You cannot specify stream access
for the DELETE statement if it is not embedded as a table reference in a SELECT statement.
See “SELECT Statement” (page 164).
[AFTER LAST ROW]
causes the stream to skip all existing rows in the table and delete only rows that are
published after the statement is issued.
SET ON ROLLBACK set-roll-clause [,set-roll-clause]...
causes one or more columns to be updated when the execution of the DELETE statement
causes its containing transaction to be rolled back.
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.
If expression refers to columns being updated, Neoview SQL uses the original
values to evaluate the expression and determine the new value.
See “Expressions” (page 255).
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” (page 305).
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 using the PURGEDATA utility.
[FOR] access-option ACCESS
specifies the access option required for data used to evaluate the search condition. See “Data
Consistency and Access Options” (page 25).
READ COMMITTED
specifies that any data used to evaluate the search condition must come from committed
rows.
DELETE Statement 109