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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-110
DELETE Statement
ROWSET FOR INPUT SIZE rowset-size-in
Allowed only if you specify rowset-search-condition in the WHERE clause.
rowset-size-in restricts the size of the input rowset to the specified size. If
rowset-size-in is different from the allocated size for the rowset,
NonStop SQL/MX uses the smaller of the two sizes and ignores the remaining
entries in the larger rowset.
rowset-size-in must be an integer literal (exact numeric literal, dynamic
parameter, or a host variable) whose type is unsigned short, signed short,
unsigned long, or signed long in C and their corresponding equivalents in COBOL.
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-12.
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-174.
[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.
Positioned DELETE is:
DELETE FROM table
WHERE CURRENT OF {cursor-name | ext-cursor-name}
Embed
C/COBOL
Embed
Pub/Sub
Pub/Sub