SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-152
DELETE Statement
If you do not specify rowset-size-in, NonStop SQL/MX uses the allocated
rowset size specified in the SQL Declare Section of the embedded SQL
program.
table
names the user table or view from which to delete rows. table must be either a
base table or an updatable view. To refer to a table or view, use one of these name
types:

Guardian physical name

ANSI logical name

DEFINE name
See Database Object Names on page 6-13.
The file organization of the table or base table must be key-sequenced. You cannot
use DELETE to delete rows from an SQL/MP entry-sequenced table.
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 on page 2-255.
[AFTER LAST ROW]
causes the stream to skip all existing rows in the table and delete only rows
that are published after the stream’s cursor is opened.
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
Pub/Sub
Pub/Sub