ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-77
Examples
view-name
identifies the view into which the rows are inserted; view-name can be qualified
with the database name and owner name.
The view must be an updatable NonStop SQL/MP protection view. For information
on protection views, see “Shorthand Views and Protection Views” in the CREATE
VIEW on page 4-58.
column-name
specifies a column for which a value will be supplied.
constant-expr
is a value (or the keyword NULL) for a column in the row being inserted. This list of
values must match the column-name list.
select-statement
is a SELECT statement that selects values from other tables and views to be
inserted in the table or view specified in the INTO clause.
The select list must contain an element for each column that you specify in the
column-name list.
The select-statement cannot refer to the table, view, or underlying table of the
view into which the rows are being inserted.
Examples
The following example adds one row to the EMPLOYEE table:
insert into test_disk01_persnl..employee
(empnum, first_name, last_name, deptnum, jobcode, salary)
values (1234, "Georgia", "Brown", 1001, 3004, 52300)