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-255
INSERT Statement
colnum
specifies a column by its position colnum in the select list of the query
expression. Use colnum to refer to unnamed columns, such as columns in
the derived table of a query expression other than a table or view.
ASC | DESC
specifies the sort order. The default is ASC. For ordering the source table
on a column that can contain null, nulls are considered equal to one
another but greater than non-nulls.
DEFAULT VALUES
specifies a query expression of the form VALUES (DEFAULT, ... ). The value of
each DEFAULT is the default value defined in the column descriptor of
colname, which is contained in the table descriptor of table. Each default
value is inserted into its column to form a new row.
If you specify DEFAULT VALUES, you cannot specify a column list. You can
use DEFAULT VALUES only when all columns in table have default values.
[FOR] access-option ACCESS
specifies the access option required for data accessed and returned in the source
table derived from the evaluation of a query expression that is a SELECT
statement. See Data Consistency and Access Options on page 1-8.
READ COMMITTED
specifies that any data accessed and returned in the source table derived from
the evaluation of the query expression must be from committed rows.
SERIALIZABLE | REPEATABLE READ
specifies that the INSERT statement and any concurrent process (accessing
the same data) execute as if the statement and the other process had run
serially rather than concurrently.
The default access option is the isolation level of the containing transaction, which
is determined according to the rules specified in Isolation Level
on page 10-56.
IN {SHARE | EXCLUSIVE} MODE
specifies that either SHARE or EXCLUSIVE locks be used when accessing data
specified by a SELECT statement or by a table reference in the FROM clause
derived from the evaluation of a query expression that is a SELECT statement; and
when accessing the index, if any, through which the table accesses occur.