NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-51
APPENDCANCEL Command
unless you specify the SORTED option. All considerations listed for LOAD that do
not require an Enscribe out-file are true for APPEND.
Following are the major differences between APPEND and LOAD:
°
APPEND is typically used to add data to a file that already contains data. LOAD
is typically used to enter initial data into an empty file.
°
APPEND does not erase or overwrite existing records. LOAD erases or
overwrites existing records.
°
APPEND writes only to entry-sequenced and key-sequenced SQL tables. LOAD
writes to all types of SQL tables and Enscribe files.
°
APPEND does not write to SQL tables with indexes. LOAD allows the target to
have indexes and will re-create indexes for SQL tables.
°
APPEND runs normally and reports no errors when in-file is empty. LOAD
terminates and reports an error when the input file is empty.
APPENDCANCEL Command
APPENDCANCEL is an SQLCI utility that recovers from an interrupted APPEND
operation by restoring the target table to its original state (before the APPEND operation
began). APPENDCANCEL deletes any data appended to the target table by the
interrupted APPEND operation. You should use the APPENDCANCEL command only
after an APPEND operation is interrupted by a CPU or process failure, or other
unexpected termination.
out-file
is the name (or equivalent DEFINE) of an existing entry-sequenced or key-
sequenced SQL table without indexes whose APPEND is to be canceled. out-
file must be identical to the out-file specified in the interrupted APPEND
command from which this APPENDCANCEL command is recovering.
recovery-file
is the name (or equivalent DEFINE) of a disk file APPENDCANCEL uses to restore
out-file to its original state. RECOVERYFILE is a required parameter.
recovery-file must be identical to the recovery-file specified in the
interrupted APPEND command from which this APPENDCANCEL command is
recovering.
If APPENDCANCEL is successful, it will purge recovery-file.
APPENDCANCEL out-file, RECOVERYFILE recovery-file
[ [,] PARTONLY ] ;