SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-232
UPDATE 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 to update. 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.
STREAM (table)
updates a continuous data stream from the specified table. You cannot specify
STREAM access for the UPDATE statement if it is not embedded as a table
reference in a SELECT statement. See SELECT Statement on page 2-178.
[AFTER LAST ROW]
causes the stream to skip all existing rows in the table and update only rows
that are published after the stream’s cursor is opened.
Positioned UPDATE is:
UPDATE table
SET set-clause [,set-clause]...
WHERE CURRENT OF {cursor-name | ext-cursor-name}
| WHERE CURRENT OF iterator-name
set-clause is:
column-name = {expression |rowset-expression | NULL}
Embed
C/COBOL
Java
Embed
Pub/Sub