SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-162
DELETE Statement
Use the positioned form of DELETE only in embedded SQL programs. Use the
searched form in MXCI or embedded SQL programs.
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.
Searched DELETE is:
[ ROWSET FOR INPUT SIZE rowset-size-in ]
DELETE [multi-commit-option] FROM table
| STREAM (table) [AFTER LAST ROW]
[SET ON ROLLBACK set-roll-clause [,set-roll-clause]...]
[WHERE search-condition | rowset-search-condition]
[[FOR] access-option ACCESS]
set-roll-clause is:
column-name = expression |
access-option is:
READ COMMITTED
| SERIALIZABLE
| REPEATABLE READ
| SKIP CONFLICT
Positioned DELETE is:
DELETE FROM table
WHERE CURRENT OF {cursor-name | ext-cursor-name}
MULTI COMMIT DELETE is:
multi-commit-option is:
WITH MULTI COMMIT [ granularity ]
granularity is:
EVERY num ROWS
Pub/Sub
Embed
Pub/Sub
Embed
Pub/Sub
Embed
C/COBOL
Embed