SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-14
INSERT Statement
INSERT Statement
INSERT is a DML statement that inserts a row into a table or protection view.
name
is the name of a table or protection view (or an equivalent DEFINE) in which to
insert rows. name cannot be the name of a catalog table.
[ * [ , syskey ] ]
[ syskey , * ]
[ col [ , col ] ... ]
specifies the columns in the table or view in which to insert values (including null
values) in the same order in which the values appear later in the statement:
The default is all columns, except the SYSKEY column, in the order in which
INVOKE would list them.
You can specify a SYSKEY column only for a table with relative file organization or
for a view defined on such a table.
{ VALUES ( val [, val ] ...) [ insert-opt ] ... }
{ ( select-stmt ) [ insert-opt ] ... }
{ select-stmt }
specifies the values to insert. Include a value for each column specified
previously on the INSERT statement, specify the values in the same order as
INSERT INTO { name } [ ( column-list ) ]
{ VALUES ( val [, val ] ...) [ insert-opt ] ... }
{ ( select-stmt ) [ insert-opt ] ... }
{ select-stmt }
column-list is: [ * [ , syskey ] ]
[ syskey , * ]
[ col [ , col ] ... ]
insert-opt is: { [ FOR ] { STABLE } ACCESS }
{ { REPEATABLE } }
{ }
{ { :host-var } }
{ RETURNING { LASTSYSKEY} }
{ { ?param } }
{ }
{ { APPEND | ANYWHERE } }
* All columns except the SYSKEY column
syskey The name of the SYSKEY column (usually SYSKEY)
col The unqualified name of a column