ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-52
Example
insert-value
represents a value to be inserted into the corresponding column. It can be any of
the following:
If the VALUES clause is present, INSERT inserts a single row with the specified
insert-values as column values. It assigns the first insert-value to the first
specified column, the second value to the second column, and so on. There must
be one insert-value for each column-identifier.
Example
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)
CORE SQL Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is INSERT.
INSERT in CORE SQL differs from the NonStop SQL/MP implementation in the
following ways:
insert-value Value Assigned
dynamic-
parameter
Represented by a question mark (?), it identifies a parameter in a
dynamically prepared SQL statement
literal The exact value specified
NULL A null value
USER A character string containing the logical username of the current
user
Feature In NonStop SQL/MP In CORE SQL
Can you specify the locking
mode?
Yes No, unless you use pass-through
mode.
Default locking mode STABLE ACCESS Depends on the setting of the
SQL_TXN_ISOLATION item in the
user profile table, ZNSPROF. The
default is STABLE ACCESS.