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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-146
INSERT Statement
ROWSET FOR INPUT SIZE rowset-size-in
rowset-size-in restricts the size of the input rowset to the specified size, which
must be less than or equal to the allocated size for the 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 in which to insert 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.
simple-table is:
VALUES (row-value-const) [,(row-value-const)]...
| VALUES (rowset-value-const)
| TABLE table
| SELECT [ALL | DISTINCT] select-list
FROM table-ref [,table-ref]...
| FROM ROWSET [rowset-size]
(:array-name [,:array-name]...)
[WHERE search-condition | rowset-search-condition]
[SAMPLE sampling-method]
[TRANSPOSE transpose-set [transpose-set]...
[KEY BY key-colname]]...
[SEQUENCE BY colname [ASC[ENDING] | DESC[ENDING]]
[,colname [ASC[ENDING] | DESC[ENDING]]]...]
[GROUP BY colname [,colname]...]
[HAVING search-condition | rowset-search-condition]]
[[FOR] access-option ACCESS]
[IN {SHARE | EXCLUSIVE} MODE]
rowset-value-const is:
{rowset-expr |expr | NULL | DEFAULT}
[,{rowset-expr |expr | NULL | DEFAULT}]...
access-option is:
READ COMMITTED
| SERIALIZABLE
| REPEATABLE READ
order-by-clause is:
ORDER BY {colname | colnum} [ASC[ENDING] | DESC[ENDING]]
[,{colname | colnum} [ASC[ENDING] | DESC[ENDING]]]...
Embed
Embed
MXCI
Embed