NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
I-16
Considerations—INSERT
For static SQL programs, :host-var specifies a host variable to receive the
SYSKEY. For dynamic SQL programs, LASTSYSKEY specifies a place holder to
store the SYSKEY.
?param is the name of a parameter that has the same function as LASTSYSKEY
and is included to maintain compatibility with existing programs. Use
LASTSYSKEY instead.
APPEND | ANYWHERE
specifies whether to add rows at the end of the table (APPEND) or anywhere in the
table (ANYWHERE). (Applies only to tables with relative file organization or to
protection views defined on such tables. Cannot be used if the SYSKEY column is
one of the columns for the INSERT.)
With APPEND, if you specify an ORDER clause in select-stmt, rows are
added in that order. With ANYWHERE, an ORDER clause in select-stmt has
no effect.
APPEND is the default unless the column list includes the SYSKEY.
Considerations—INSERT
•
Authorization requirements
INSERT requires authority to read and write to the table or view receiving the data
and authority to read tables and views specified in any select-stmt included in
the INSERT statement.
•
Requirements for inserted rows
To insert a row, you must provide a value for each column in the table that has no
default value. (As a result, you cannot insert a row into a protection view unless the
view includes all columns of the underlying table that are defined with the NO
DEFAULT option.)
Besides being of appropriate type and size for the corresponding columns, the
values in each row inserted must be compatible with the data types of the
corresponding columns, as follows:
°
Character values
Any character string data type is compatible with all other character string data
types that have the same character set.
For character columns, inserted values shorter than the column length are
padded on the right with single-byte ASCII blanks (HEX 20); longer values are
truncated on the right. For varying-length character columns, shorter inserted
values are not padded; values longer than the maximum length are truncated on
the right.
°
Numeric values
Any numeric data type is compatible with all other numeric data types.