SQL/MP Reference Manual
HP NonStop SQL/MP Reference Manual—523352-013
A-53
Considerations—APPEND
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. For a full description of each
append-option, see LOAD Command on page L-18.
Considerations—APPEND
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. For information about these commands, see the
TACL Reference Manual.
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.
If it is not partitioned, a key-sequenced target table is unavailable to applications
during the APPEND operation. If the table is partitioned and you do not specify
PARTONLY, the partition into which the first new row was added and all
subsequent partitions are unavailable. The whole table is unavailable for a short
time at the start of APPEND, so this is not really an online operation. If you do
specify PARTONLY, only the partition to which APPEND adds data is unavailable
during the APPEND operation.
To append data to several partly-full partitions of a table, execute an APPEND
PARTONLY command for each partition, giving each its own input file.