NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-48
Considerations—APPEND
out-file
is the name (or equivalent DEFINE) of an existing entry-sequenced or key-
sequenced SQL table to which to append data. Neither type of file can have indexes.
recovery-file
is the name (or equivalent DEFINE) of a disk file APPEND creates to hold data for
recovery in case of interruption or failure in restoring out-file to its pre failure
state. RECOVERYFILE is a required parameter.
append-option
is one or more options that configure the APPEND operation. The append-
option list is identical to load-option in the LOAD command, except you
cannot APPEND data to an Enscribe file. Therefore, Enscribe-specific LOAD
options are not valid for an APPEND operation. See LOAD Command
on page L-17
for a full description of each append-option.
Considerations—APPEND
•
Authorization requirements
APPEND requires authority to read in-file and write to out-file. You must
also have authority to read the catalogs in which in-file (if it is a table) and
out-file are described.
recovery-file inherits the default file creation security of the user who
executes APPEND. Because APPEND copies some data from out-file to
recovery-file, if out-file contains sensitive information and the APPEND
operation fails, the security of this information can be compromised. To protect
sensitive information during an APPEND operation, set the user's default file
creation recovery-file security appropriately. You can change default file
creation security temporarily in the TACL VOLUME command or permanently in
the TACL DEFAULT command. See the TACL Reference Manual for more
information about these commands.
•
APPEND operations
For an entry-sequenced target table, APPEND adds new data to the end of the table.
If the table is not partitioned, it is unavailable to applications during the APPEND
operation. If the table is partitioned, the partition into which the first new row was
added and all subsequent partitions are unavailable during the APPEND operation.
The whole table is unavailable for a short time at the start of APPEND, so this is not
really an online operation.
For a key-sequenced target table, the key value of every new row to add must be
logically greater than the key value of the last original row of the table. If you
append data to only one partition (APPEND PARTONLY), the key value of every
new row to add must be logically greater than the key value of the last original row
of the partition and logically less than the starting key value of the next partition. To
interleave new rows with original rows, use COPY.